Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “subsoil” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
subsoil96729(None) 
subsoils1076651subsoils
subcool1146232subcool
subgoal1046322subgoal
subjoin1645442subjoin
subskill1444232subskill
subsocial1345822subsocial
subsoiled1245452subsoiled
subsoiler1145322subsoiler
subsonic1245752subsonic
aboil72217543_ab_oil
abseil837183_abseil
assoil688543_assoil
boil66335183__b_oil
broil74918223__broil
cuboid1139503cub_oid
embroil1146613embroil
fusil84715323fu_s_il
gumboil1244373gumboil
lugsail843443lugsail
outsail71411413outsail
reboil83814683reb_oil
skysail1462843skysail
soil46138833___soil
spoil75818653s__poil
stunsail843023stunsail
suasion739363suasion
suasory1046043suasory
subacid1248473subacid
subarid10310653subarid
subaxial1745293subaxial
subcell1146753subcell
subcode1237163subcode
subcools1245753subcools
subdual10126713subdual
subedit1049403subedit
suberic11312213suberic
suberin9314563suberin
subfile122010503sub_file
subfix1835073sub_fix
subfossil1451933subfossil
subgoals1145553subgoals
subjoins1745453subjoins
sublot82315523sublo_t
sublots92410913sublots
submit10312673sub_mit
subnodal1145043subnodal
suboral92011993suboral
suborn8310013sub_orn
suboval12216723suboval
subs66037123subs___
subsale9310543subsale
subscale1247603subscale
subsea82610193subs_ea
subsect112611843subsect
subsere9311443subsere
subset83122583subs_et
subsets92813103subsets
subshell1344883subshell
subside10410453subside
subsidy1345973subsidy
subsist9311573subsist
subsite9412873subsite
subskills1543773subskills
subsoilers1244063subsoilers
subsoiling1344873subsoiling
subsolar1045113subsolar
subsume1146713subsume
subtile91912623sub_tile
subtone9310343subtone
subtonic1246923subtonic
subtopia1245403subtopia
subtopic1445073subtopic
subtotal1046263subtotal
subunit948953subunit
subvocal1544993subvocal
subworld1444193subworld
subzone1846993subzone
sunsuit748693sunsuit
surveil1045093surveil
sushi8310493su_shi_
sushis9311183su_shis
suslik1036373su_slik
topsoil977143topsoil
turmoil944723turmoil
uncoil8811853_uncoil
upboil1096453_upboil
upcoil10126193_upcoil

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.423422437.4
2DLD Change Limit134027886.98619185.1
3Display Results88880.0302933.3
 (SQL Overall)178691887.43924020.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.