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

127 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
swizzles195378(None) 
sizzles15349631s_izzles
swizzle1854101swizzle_
swizzled2053011swizzled
swizzler1963221swizzler
swizzlers2052191swizzlers
drizzles17295292drizzles
fizzles18339062_fizzles
frizzles19297282frizzles
grizzles17286192grizzles
mizzles17329492_mizzles
pizzles17329272_pizzles
sizzle14309612s_izzle_
sizzled16367882s_izzled
sizzler15266862s_izzler
sizzlers16274752s_izzlers
swindles12319502swindles
swingles12319542swingles
swiples12339642swi_ples
swipples1534842swipples
wizzes175110772_wizz_es
zizzles14307092_zizzles
bizzes163910843_bizz_es
dazzles1636413_dazzles
dizzies16279753_dizzies
drizzle16285913drizzle_
drizzled18284573drizzled
dwindles13366023dwindles
fizzes174512553_fizz_es
fizzle17369713_fizzle_
fizzled19357273_fizzled
frazzles19284813frazzles
frizzes18338183frizz_es
frizzies19315933frizzies
frizzle18367043frizzle_
frizzled20325703frizzled
frizzler19345843frizzler
frizzlers20293673frizzlers
grizzle16306113grizzle_
grizzled18334893grizzled
grizzler17335033grizzler
grizzlers18253233grizzlers
grizzlies18123193grizzlies
guzzles16328043_guzzles
mizzle16279993_mizzle_
mizzled18327633_mizzled
muzzles17299683_muzzles
nozzles15276303_nozzles
nuzzles15298123_nuzzles
pizzle16279493_pizzle_
puzzles17318973_puzzles
quizzes2435573quizz_es
scuzzes1734403scuzz_es
seizes154317533sei_z_es
seizures1744633seizures
shingles123111113shingles
sickles133417543s_ickles
sidles74721153s_i_dles
similes92915233s_imiles
simples113014943s_imples
singles83520433s_ingles
sizes146727763s_i_z_es
skiffles18265713skiffles
skittles1245763skittles
smiles84522293smi__les
sniffles14257723sniffles
sniggles10307313sniggles
snoozles17335563snoozles
sozzled16265183s_ozzled
spatzles1935303spatzles
spazzes1735263spazz_es
spicules12219803spicules
spiles84227913spi__les
spindles112710353spindles
spinules10249333spinules
spittles1038333spittles
spitzes1849183spitz_es
stickles142512103stickles
stifles103013393sti_fles
stiles64328773sti__les
stipples1247023stipples
stipules1037053stipules
swaddles13296453swaddles
swales93920763sw__ales
swiftlet1444793swiftlet
swiftlets1542723swiftlets
swilled113611833swi_lled
swiller103211663swi_ller
swillers11299113swi_llers
swills94213363swi__lls
swindle11389183swindle_
swindled13307623swindled
swindler12257723swindler
swindlers13306033swindlers
swinges113413423swi_nges
swingle113510563swingle_
swingled13337433swingled
swipes114114333swi__pes
swiple11379233swi_ple_
swipple1444633swipple_
swirled11308223swi_rled
swirls94010133swi_rl_s
swishes133411373swi_shes
swisses10417143swi_sses
switches16159133switches
swiveled1544163swiveled
swivels13396773swivel_s
swives123915183swi__ves
swizzling2142493swizzling
tizzies15287893_tizzies
twiddles13265613twiddles
twinkles1535073twinkles
whizzes2134713whizz_es
widdles123514343_widdles
wiggles123312463_wiggles
wiles85437873_wi__les
wimbles143010853_wimbles
wimples143311173_wimples
windles113518493_windles
winkles143412773_winkles
wintles103414983_wintles
winzes184313053_winz_es
wizes174723343_wi_z_es
wizzen17387203_wizz_en
wizzens18385483_wizzens
zizzle13247313_zizzle_
zizzled15315853_zizzled

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621277.59619242.0
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.07822120.7
 
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.