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 “succoth” 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.

57 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
succoth144509(None) 
succah1336642succ_ah
succor1036622succo_r
succors1137412succors
succory1444642succory
succotash1651882succotash
succour1144692succour
sukkoth1342092sukkoth
cloth105817543__cloth
puccoon1343503puccoon
quoth173310353qu__oth
saccate111311763saccate
sackcloth2072983sackcloth
scooch13228123s_cooch
scoot75729153s_coot_
scootch1434463s_cootch
scoots85315943s_coots
scot66242613s__cot_
scotch13207523s__cotch
scots74025913s__cots
scouth115011153s_couth
scrota8310203s_crota
secco9312423secco__
seccos1039923secco_s
selcouth1344093selcouth
sloth85019453s__loth
smooth11259203s_mooth
sooth85924063s__ooth
soth75932523s___oth
stucco1044253stucco__
stuccoed1352853stuccoed
stuccoer1252803stuccoer
stuccoes1254273stuccoes
stuccos1153933stucco_s
subcode1237163subcode
subcool1146233subcool
sublot82315523sublot_
sublots92410913sublots
succahs1435323succahs
succeed1235983succeed
success1146403success
succored13135173succored
succorer12124683succorer
succours1244593succours
succuba1343443succuba
succubi1342883succubi
succumb1543283succumb
succuss1134993succuss
such96424813su_c__h
sucrose939303sucrose
sukkot936643sukkot_
sulcate9314423sulcate
sunbath1236423sunbath
surcoat9412923surcoat
surcoats1047943surcoats
uncouth1247173_uncouth
yucch15417433yucc__h

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.390458182.1
2DLD Change Limit134027576.56320421.6
3Display Results57570.0301900.0
 (SQL Overall)178691576.98325589.4
 
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.