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

107 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
dizzying213302(None) 
dazzling1834362dazzling
dirtying1336092dirtying
divvying1932772divvying
dizening19177162dizening
dizzyingly2651332dizzyingly
drizzling1943022drizzling
fizzing19276402fizz_ing
fizzling20264992fizzling
mizzling19255442mizzling
sizzling17225782sizzling
zizzling16233922zizzling
buzzing18186543buzz_ing
cozying22308083_cozying
dairying1336353dairying
dallying13368493dallying
dazing175516513d_az_ing
decaying15239453decaying
decoying15208763decoying
decrying15237413decrying
defying15328823d_efying
deifying1637633deifying
delaying133210973delaying
denying123711293d_enying
dialing94318173di_aling
dialling10310783dialling
dialysing1444483dialysing
dialyzing2344043dialyzing
diazin1639163diaz_in_
diazine1738933diaz_ine
diazins1739183diaz_ins
dibbing133110893di_bbing
dibbling14247333dibbling
dicing105718763di__cing
dicking153617613di_cking
diddling12228743diddling
dieing84018653di__eing
dieting93616833di_eting
digging113513703di_gging
dighting142510843dighting
diking124320243di__king
dilating102714913dilating
diluting10248983diluting
dimming13339593di_mming
dimpling14199023dimpling
dindling112411163dindling
dinging103618613di_nging
dining84525133di__ning
dinking133618283di_nking
dinning93416553di_nning
dinting93520553di_nting
dipping134014833di_pping
dirking133812603di_rking
dirling93316073di_rling
discing113914593di_scing
discoing12511453discoing
dishing124017103di_shing
disking134615493di_sking
dismaying1656823dismaying
dissing94517683di_ssing
disusing1039013disusing
ditching15349943ditching
dittoing1036263dittoing
dividing1437183dividing
diving113717953di__ving
divining1338413divining
dizzied17236133dizz_ied
dizzier16317543dizz_ier
dizzies16279753dizz_ies
dizzily1934843dizz_ily
dizzy177410853dizzy___
dollying13407423dollying
dozening19236213dozening
dozing174214203d_oz_ing
draying123813843d_raying
drying113411603d__rying
dummying17263723dummying
dying105316033d___ying
edifying1636083edi_fying
frizzing2064803frizz_ing
frizzling2153113frizzling
fuzzing19336183fuzz_ing
giddying1533783giddying
gillying13306813gillying
gipsying1533373gipsying
grizzling1942843grizzling
guzzling18225063guzzling
hinnying15124853hinnying
huzzaing2042433huzzaing
inlying1168153_inlying
jazzing2333883jazz_ing
jimmying2342383jimmying
lazying2046673_lazying
mislying1437843mislying
muzzling19245733muzzling
nuzzling17224773nuzzling
pitying132910243pi_tying
puzzling19225393puzzling
quizzing2643403quizz_ing
razzing1636323razz_ing
sizing163616443si_z_ing
swizzling2142493swizzling
tidying1238513ti_dying
vizoring2134573vizoring
whizzing2333383whizz_ing
willying15306713willying
wizening21255483wizening

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621077.19020328.5
3Display Results1071070.0303566.7
 (SQL Overall)1786911077.65623340.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.