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 “dizzily” 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
dizzily193484(None) 
dingily1238102dingily
dirtily1138582dirtily
dizzied17236132dizzied
dizzier16317542dizzier
dizzies16279752dizzies
dizzy177410852dizz__y
dozily19329102d_ozily
drizzly19364552drizz_ly
frizzily2253142frizzily
fuzzily2145072fuzzily
jazzily2533372jazzily
mizzly19256102mizz_ly
muzzily2045022muzzily
ritzily1945142ritzily
airily93014823ai_rily
boozily2135623boozily
cozily20349703_cozily
crazily2136923crazily
daffily1735143daffily
daily95922333d__aily
daintily1245523daintily
dandily12279633dandily
daylily1434983daylily
dazedly2134063dazedly
dazzle1536853dazz_le
dewily1338343d_ewily
diazin1639163diazi_n
diazine1738933diazine
diazins1739183diazins
diazole1736793diazole
dicliny1337673dicliny
dicycly1843273dicycly
diddly12389573di_ddly
dignify1543893dignify
dignity1236463dignity
dilly94923783di__lly
dimity12310483di_mity
dimly114913483di__mly
dimply14339743di_mply
dinkly144311083di_nkly
direly10311563di_rely
distil73616433distil_
distill83011323distill
distils83015803distils
ditzier17307963ditzier
ditzy186513283ditz__y
dizziest17266723dizziest
dizzying2133023dizzying
dizzyingly2651333dizzyingly
doily95321033d__oily
doomily1336133doomily
dopily123510463d_opily
dottily1147283dottily
dowdily1534953dowdily
drily95816523d__rily
drippily1643033drippily
drizzle16285913drizz_le
dumpily1566233dumpily
duskily15236753duskily
dustily113211533dustily
fierily1339023fierily
filmily1535733filmily
fishily1637643fishily
fizzier18326713fizzier
fizzing19276403fizzing
fizzle17369713fizz_le
fizzy199015083fizz__y
frizzly21455793frizz_ly
gauzily2034393gauzily
giddily1335073giddily
glazily2035383glazily
grizzly19354473grizz_ly
hazily2179063_hazily
icily101211693_i_cily
ickily1535753_ickily
kinkily1335223kinkily
lazily1859713_lazily
mazily20610393_mazily
milkily16216553milkily
mirkily16266403mirkily
mistily122612343mistily
mizzle16279993mizz_le
niftily1335753niftily
nippily1444713nippily
oilily93111723oi_lily
oozily18328073_oozily
pithily1567033pithily
pizzle16279493pizz_le
riskily1436413riskily
silkily14236963silkily
sillily10209783sillily
sizably2136613sizably
sizzle14309613sizz_le
tidily102811393ti_dily
tinily94014433ti_nily
tinnily1047363tinnily
tipsily1236043tipsily
tizzies15287893tizzies
tizzy16548893tizz__y
wilily123310763wi_lily
windily1437943windily
wirily123310783wi_rily
wispily1535653wispily
wittily1336173wittily
woozily2234383woozily
zizzle13247313zizz_le

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.406440125.6
2DLD Change Limit1340271077.03019065.0
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.48223882.8
 
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.