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

120 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
swizzle185410(None) 
sizzle14309611s_izzle
swizzled2053011swizzled
swizzler1963221swizzler
swizzles1953781swizzles
drizzle16285912drizzle
fizzle17369712_fizzle
frizzle18367042frizzle
grizzle16306112grizzle
mizzle16279992_mizzle
pizzle16279492_pizzle
sizzled16367882s_izzled
sizzler15266862s_izzler
sizzles15349632s_izzles
swindle11389182swindle
swingle113510562swingle
swiple11379232swi_ple
swipple1444632swipple
swizzlers2052192swizzlers
zizzle13247312_zizzle
dazzle1536853_dazzle
drizzled18284573drizzled
drizzles17295293drizzles
drizzly19364553drizzly
dwindle12415883dwindle
fizzled19357273_fizzled
fizzles18339063_fizzles
frazzle18305223frazzle
frizzled20325703frizzled
frizzler19345843frizzler
frizzles19297283frizzles
frizzly21455793frizzly
grizzled18334893grizzled
grizzler17335033grizzler
grizzles17286193grizzles
grizzly19354473grizzly
guzzle15297913_guzzle
mizzled18327633_mizzled
mizzles17329493_mizzles
mizzly19256103_mizzly
muzzle16319393_muzzle
nozzle14236633_nozzle
nuzzle14298083_nuzzle
pizzles17329273_pizzles
puzzle16318603_puzzle
seizable1938723seizable
seize143819503sei_z_e
seizure1634683seizure
shingle117711283shingle
sickle124418323s_ickle
sidle65124033s_i_dle
simile83115633s_imile
simple104315173s_imple
single74520603s_ingle
sizable1839893s_izable
size135630963s_i_z_e
sizzlers16274753s_izzlers
skiable1338883skiable
skiffle17225203skiffle
skittle1135533skittle
smile74823923smi__le
sniffle13287653sniffle
sniggle9316833sniggle
snoozle16305913snoozle
sozzled16265183s_ozzled
spatzle1834583spatzle
spicule11269933spicule
spile75230083spi__le
spindle103210093spindle
spinule9299993spinule
spittle937923spittle
stickle132410973stickle
stifle93611903sti_fle
stile54931573sti__le
stipple1146623stipple
stipule936723stipule
swaddle12276743swaddle
swale85221593sw__ale
swiftlet1444793swiftlet
swiftly1633733swiftly
swill83417373swi__ll
swilled113611833swi_lled
swiller103211663swi_ller
swills94213363swi_lls
swindled13307623swindled
swindler12257723swindler
swindles12319503swindles
swine85625303swi__ne
swinge105614383swi_nge
swingled13337433swingled
swingles12319543swingles
swipe105217083swi__pe
swiples12339643swi_ples
swipples1534843swipples
swirl84514143swi_rl_
swirled11308223swi_rled
swirls94010133swi_rls
swirly12439253swi_rly
swithe124010683swi_the
swithly1634443swithly
swive115316193swi__ve
swivel12369323swivel_
swiveled1544163swiveled
swivels13396773swivels
swizzling2142493swizzling
twiddle12305483twiddle
twinkle1464773twinkle
widdle113814843_widdle
wiggle113713013_wiggle
wile75944373_wi__le
wimble133211923_wimble
wimple133611363_wimple
windle104617953_windle
winkle133812833_winkle
wintle94014603_wintle
winze175014853_winz_e
wizzen17387203_wizzen
wizzes175110773_wizzes
zizzled15315853_zizzled
zizzles14307093_zizzles

Search took 7 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 Limit1340271205.64023763.7
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.07629409.3
 
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.