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

205 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
zizzles1430709(None) 
fizzles18339061fizzles
mizzles17329491mizzles
pizzles17329271pizzles
sizzles15349631sizzles
zizzle13247311zizzle_
zizzled15315851zizzled
bizzes163910842bizz_es
dazzles1636412dazzles
dizzies16279752dizzies
drizzles17295292drizzles
fizzes174512552fizz_es
fizzle17369712fizzle_
fizzled19357272fizzled
frizzles19297282frizzles
grizzles17286192grizzles
guzzles16328042guzzles
mizzle16279992mizzle_
mizzled18327632mizzled
muzzles17299682muzzles
nozzles15276302nozzles
nuzzles15298122nuzzles
pizzle16279492pizzle_
puzzles17318972puzzles
sizzle14309612sizzle_
sizzled16367882sizzled
sizzler15266862sizzler
sizzlers16274752sizzlers
swizzles1953782swizzles
tizzies15287892tizzies
wizzes175110772wizz_es
aisles64721143ai_sles
azoles154614613_azoles
bibles104617643bi_bles
biles75542143bi__les
bindles104016453bindles
birles84920643bi_rles
bizes165923663bi_z_es
bizones1837823bizones
buzzes165011173buzz_es
circles1139903circles
citoles9312553citoles
cozzes164510893cozz_es
dazzle1536853dazzle_
dazzled1735033dazzled
dazzler1634713dazzler
dazzlers1733233dazzlers
diazoles1836323diazoles
dibbles124013333dibbles
diddles103915073diddles
dimples122813213dimples
dindles93817243dindles
dingles93818323dingles
dipoles101013753dipoles
ditzes163212423ditz_es
dizzied17236133dizzied
dizzier16317543dizzier
dizziest17266723dizziest
drizzle16285913drizzle_
drizzled18284573drizzled
fezzes174910403fezz_es
fiddles123212603fiddles
files85441273fi__les
filles94224523fi_lles
fimbles143510653fimbles
finales104016013finales
fipples14298653fipples
fizzed18369443fizz_ed
fizzer17369383fizz_er
fizzers18357003fizzers
fizzier18326713fizzier
fizziest19226073fizziest
foozles19329543foozles
frazzles19284813frazzles
frizzes18338183frizz_es
frizzies19315933frizzies
frizzle18367043frizzle_
frizzled20325703frizzled
frizzler19345843frizzler
frizzlers20293673frizzlers
fuzzes175412253fuzz_es
giggles103312933giggles
ginzoes1735433ginzoes
girdles92210003girdles
grizzle16306113grizzle_
grizzled18334893grizzled
grizzler17335033grizzler
grizzlers18253233grizzlers
grizzlies18123193grizzlies
guzzle15297913guzzle_
guzzled17326263guzzled
guzzler16286563guzzler
guzzlers17274863guzzlers
higgles123911803higgles
hirples12149643hirples
hirsles101510073hirsles
idles66720123_i_dles
ingles74420873_ingles
inkles103515653_inkles
isles54220563_i_sles
istles62814983_istles
ixtles13217063_ixtles
jazzes21347883jazz_es
jiggles164111433jiggles
jingles153816383jingles
kibbles153510253kibbles
kindles123614843kindles
kirtles11309663kirtles
kittles113012493kittles
lezzes14387833lezz_es
lezzies1536203lezzies
ligules82210913ligules
lisles63416283li_sles
littles73212783littles
mickles153415003mickles
middles113415303middles
miggles113512033miggles
miles74645073mi__les
milles84526563mi_lles
mingles103719003mingles
mizzen16447953mizz_en
mizzens17366123mizzens
mizzly19256103mizzl_y
muzzle16319393muzzle_
muzzled18267753muzzled
muzzler17257943muzzler
muzzlers18245203muzzlers
nibbles114011693nibbles
nickles133713823nickles
niggles93512203niggles
nipples11319663nipples
nozzle14236633nozzle_
nuzzle14298083nuzzle_
nuzzled16276393nuzzled
nuzzler15296493nuzzler
nuzzlers16244753nuzzlers
pickles153215443pickles
piddles114314273piddles
piffles15368763piffles
piles74742613pi__les
pilules9510623pilules
pimples133012423pimples
pinoles93418703pinoles
pintles94118723pintles
pizazzes1742373pizazzes
pizzas1646983pizz_as
pizzazes1752513pizzazes
pizzelles1942943pizzelles
pozoles1839063pozoles
puzzle16318603puzzle_
puzzled18286653puzzled
puzzler17276963puzzler
puzzlers18295143puzzlers
quizzes2435573quizz_es
razzes144910063razz_es
riddles93215023riddles
riffles133911163riffles
rifles94217703ri_fles
riles55343643ri__les
rilles64725503ri_lles
rimples113114223rimples
ripples113513293ripples
ritzes154812943ritz_es
sickles133417543sickles
sidles74721153si_dles
similes92915233similes
simples113014943simples
singles83520433singles
sizes146727763si_z_es
sozzled16265183sozzled
swizzle1854103swizzle_
swizzled2053013swizzled
swizzler1963223swizzler
swizzlers2052193swizzlers
teazles16308913teazles
tickles133416853tickles
tiles55542103ti__les
tingles83818313tingles
tinkles113713923tinkles
tipples112811253tipples
titles63719923ti_tles
tittles73413253tittles
touzles16359223touzles
vittles103211113vittles
vizslas1943143vizslas
whizzes2134713whizz_es
widdles123514343widdles
wiggles123312463wiggles
wiles85437873wi__les
wimbles143010843wimbles
wimples143311173wimples
windles113518493windles
winkles143412773winkles
wintles103414983wintles
winzes184313053winz_es
wizes174723343wi_z_es
wizzen17387203wizz_en
wizzens18385483wizzens
zigzags1742273zigzags
zilches21326303zilches
zills144020783zi__lls
zines145232653zi__nes
zipless18276303zi_pless
zizzling16233923zizzling
zonules1647793zonules

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.1731032896.0
2DLD Change Limit1340272057.07618941.1
3Display Results2052050.0802562.5
 (SQL Overall)1786912057.32924381.4
 
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.