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 “topmast” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
topmast113812(None) 
topmasts1244971topmasts
topmost1148171topmost
toast55831012to__ast
atomist92915763ato_mist
boast75935703bo__ast
bombast1348223bombast
bypast13117373byp_ast
coast75236273co__ast
comas95833003co_mas_
commas124814573commas_
compact153712213compact
compart134016003compart
compas125817063compas_
compass13379563compass
compost134515353compost
copras103517153copras_
copyist1439053copyist
cosmist11311333cosmist
cytoplast1646663cytoplast
demast9517063_demast
dismast10311233dismast
dogmas105011243dogmas_
dolmas95213043dolmas_
dopant9316133dop_ant
dopas85019063dop_as_
dopiest103315993dopiest
dormant102814373dormant
doumas95314813doumas_
durmast1037623durmast
foremast1348613foremast
formant123416003formant
format113021353forma_t
formats123113573formats
koppas14407603koppas_
kormas124511233kormas_
loumas84812333loumas_
mast65959963___mast
mommas94110653mommas_
mopiest113014293mopiest
nomas74726413no_mas_
nonpast939033nonpast
oast47156323_o__ast
oblast8613663_oblast
omasa749483_o_masa
otoplasty1454183otoplasty
past65959013__p_ast
poppas93710713poppas_
repast83520633rep_ast
roast56230143ro__ast
ropiest93317773ropiest
somas76030373so_mas_
sophist12311563sophist
stomas84816323sto_mas_
tamest85721293t_amest
tapas74627713tap_as_
tempest1139223tempest
tepas76521683tep_as_
tipcart1148833tipcart
tipcat10312653tipca_t
tipcats1137103tipcats
toasts65914993to__asts
toasty9509563to__asty
toeas55726423to_eas_
togas67823003to_gas_
tolas54532773to_las_
toman75724053to_ma_n
tomans85419133to_mans
tomato8313453to_mato
tombs97818733to_mbs_
tomcat101013453to_mcat
tomcats11127773tomcats
tomes76037383to_mes_
toms68343493to_m_s_
tomtit8413853to_mtit
tongas74315523tongas_
toniest73218903toniest
tonoplast1146913tonoplast
topaz16315323top_a_z
topcoat1179313topcoat
topcoats1245193topcoats
topees85519703topees_
topers85025323topers_
topes76941763top_es_
tophes115218423tophes_
tophs105220053top_hs_
tophus115210363tophus_
topiary1245813topiary
topics104714583topics_
topis76025833top_is_
topknot1346423topknot
topless92511123topless
topos75726393top_os_
tops66248123top__s_
topsail976523topsail
toras55540373to_ras_
torment9316173torment
tortas64918253tortas_
tost48351923to___st
totemist1049033totemist
tourist7313203tourist
towmont1277633towmont
typecast1545273typecast
typiest1238203typiest
typist1139823typ_ist
upcast102710093_upcast
upmost1068193_upmost
utopias9117723utopias_
utopist938693utop_ist

Search took 9 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.406440125.6
2DLD Change Limit1340271097.58017681.7
3Display Results1091090.0303633.3
 (SQL Overall)1786911098.01622291.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.