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

115 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
swizzled205301(None) 
sizzled16367881s_izzled
swizzle1854101swizzle_
swizzler1963221swizzler
swizzles1953781swizzles
drizzled18284572drizzled
fizzled19357272_fizzled
frizzled20325702frizzled
grizzled18334892grizzled
mizzled18327632_mizzled
sizzle14309612s_izzle_
sizzler15266862s_izzler
sizzles15349632s_izzles
sozzled16265182s_ozzled
swilled113611832swi_lled
swindled13307622swindled
swingled13337432swingled
swirled11308222swi_rled
swiveled1544162swiveled
swizzlers2052192swizzlers
zizzled15315852_zizzled
dazzled1735033_dazzled
dizzied17236133_dizzied
drizzle16285913drizzle_
drizzles17295293drizzles
dwindled14385023dwindled
fizzed18369443_fizz_ed
fizzle17369713_fizzle_
fizzles18339063_fizzles
frazzled20303993frazzled
frizzed19375973frizz_ed
frizzle18367043frizzle_
frizzler19345843frizzler
frizzles19297283frizzles
grizzle16306113grizzle_
grizzler17335033grizzler
grizzles17286193grizzles
guzzled17326263_guzzled
mizzle16279993_mizzle_
mizzles17329493_mizzles
muzzled18267753_muzzled
nuzzled16276393_nuzzled
pizzle16279493_pizzle_
pizzles17329273_pizzles
puzzled18286653_puzzled
quizzed2534043quizz_ed
sailed74327763sai__led
seized164313653sei_z_ed
shilled113313623shi_lled
shingled13358313shingled
sickled144713433s_ickled
sidled84215173s_i_dled
singled93914683s_ingled
sized155519243s_i_z_ed
sizzlers16274753s_izzlers
skiffled19244423skiffled
skilled123110863ski_lled
skirled12348183ski_rled
smiled93716433smi__led
sniffled15276433sniffled
sniggled11275743sniggled
sniveled1255463sniveled
snoozled18344493snoozled
soiled73822473soi__led
spieled104811883spi_eled
spiled94621993spi__led
spilled103613623spi_lled
spindled12287643spindled
spiraled1137723spiraled
stickled15298973stickled
stifled113511093sti_fled
stilled83314773sti_lled
stippled1345303stippled
stipuled1134453stipuled
swaddled14254963swaddled
swelled113211693sw_elled
swiftlet1444793swiftlet
swigged13327183swi_gged
swiller103211653swi_ller
swindle11389183swindle_
swindler12257723swindler
swindles12319503swindles
swinged123810793swi_nged
swingle113510563swingle_
swingles12319543swingles
swinked15349033swi_nked
swiped123811093swi__ped
swiple11379233swi_ple_
swiples12339643swi_ples
swipple1444633swipple_
swipples1534843swipples
swished14418843swi_shed
switched17157133switched
swived133610633swi__ved
swivelled1662963swivelled
swizzling2142493swizzling
twiddled14284633twiddled
twilled11398033twi_lled
twinkled1663943twinkled
twirled11385983twi_rled
whizzed2234063whizz_ed
widdled133511233_widdled
wiggled13299603_wiggled
wiled95231553_wi__led
willed104722453_wi_lled
wimbled15298153_wimbled
wimpled15338823_wimpled
windled123713483_windled
winkled15299593_winkled
wintled11339843_wintled
wizened20275423_wizened
wizzen17387203_wizz_en
wizzes175110773_wizz_es
zizzle13247313_zizzle_
zizzles14307093_zizzles

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.1561145455.1
2DLD Change Limit1461621156.79621507.1
3Display Results1151150.0303833.3
 (SQL Overall)1786911156.98225593.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.