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

300 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
mizzle1627999(None) 
fizzle17369711fizzle
mizzled18327631mizzled
mizzles17329491mizzles
mizzly19256101mizzly
muzzle16319391muzzle
pizzle16279491pizzle
sizzle14309611sizzle
zizzle13247311zizzle
dazzle1536852dazzle
drizzle16285912drizzle
fizzled19357272fizzled
fizzles18339062fizzles
frizzle18367042frizzle
grizzle16306112grizzle
guzzle15297912guzzle
mickle143715132mickle
middle103414982middle
miggle104012112miggle
mile66352572mi__le
mille75029132mi_lle
mingle93518782mingle
mizzen16447952mizzen
muzzled18267752muzzled
muzzler17257942muzzler
muzzles17299682muzzles
nozzle14236632nozzle
nuzzle14298082nuzzle
pizzles17329272pizzles
puzzle16318602puzzle
sizzled16367882sizzled
sizzler15266862sizzler
sizzles15349632sizzles
swizzle1854102swizzle
zizzled15315852zizzled
zizzles14307092zizzles
aisle55223193ai_sle
amiable11312033amiable
azole145118033_azole
bemuzzle2072533bemuzzle
bible95119423bi_ble
bile66147183bi__le
bindle94516263bindle
birle75023633bi_rle
bize155926293bi_z_e
bizone1738603bizone
bizzes163910843bizzes
cicale10314503cicale
circle1039703circle
citole8311503citole
dazzled1735033dazzled
dazzler1634713dazzler
dazzles1636413dazzles
diazole1736793diazole
dibble114013843dibble
diddle94915213diddle
dimple113512793dimple
dindle84417223dindle
dingle84317073dingle
dipole91112853dipole
dizzied17236133dizzied
dizzier16317543dizzier
dizzies16279753dizzies
dizzily1934843dizzily
dizzy177410853dizz_y
drizzled18284573drizzled
drizzles17295293drizzles
drizzly19364553drizzly
embezzle2042113embezzle
fickle153912973fickle
fiddle113613383fiddle
file75446643fi__le
fille84327403fi_lle
fimble133611753fimble
finale94116763finale
fipple13329063fipple
fizz157519823fizz__
fizzed18369443fizzed
fizzer17369383fizzer
fizzes174512553fizzes
fizzier18326713fizzier
fizzy199015083fizz_y
foozle18369203foozle
frazzle18305223frazzle
frizzled20325703frizzled
frizzler19345843frizzler
frizzles19297283frizzles
frizzly21455793frizzly
giggle94313513giggle
girdle82110463girdle
grizzled18334893grizzled
grizzler17335033grizzler
grizzles17286193grizzles
grizzly19354473grizzly
guzzled17326263guzzled
guzzler16286563guzzler
guzzles16328043guzzles
higgle113811743higgle
hirple11158973hirple
hirsle9159573hirsle
idle55423763_i_dle
impale102811663impale
ingle64120433_ingle
inkle94515833_inkle
isle45121703_i_sle
istle52214713_istle
ixtle12168013_ixtle
jiggle153811993jiggle
jingle143815223jingle
kibble143910953kibble
kindle114414233kindle
kirtle10309473kirtle
kittle104012173kittle
lezzie1435333lezzie
liable81415813liable
ligule74010833ligule
lisle53916723li_sle
little63312163little
mackle143716433mackle
macle96127003m_acle
macule104115273macule
maile75232223m_aile
maize164618563maiz_e
male66052293m__ale
mangle93921323mangle
mantle84420923mantle
maple95521143m_aple
marble104219103marble
maze155434973m_az_e
mazily20610393mazily
measle83513223measle
meddle103312763meddle
meikle1236653meikle
merle75824373m_erle
mettle83815723mettle
meze154420903m_ez_e
mezzo1537433mezz_o
mezzos1635043mezzos
miaul71612123miaul_
miauled1036663miauled
miauls8178713miauls
mice87442233mi__ce
micell1098193micell
micelle1178343micelle
miche126219243mi_che
mickler153310233mickler
mickles153415003mickles
middled123311893middled
middler112712273middler
middles113415303middles
midge95016543mi_dge
midleg1038553mi_dleg
midsole1037813midsole
miggles113512033miggles
mike105535293mi__ke
mil55752113mi__l_
milage93414123milage
mild75330853mi__ld
mildly12318243mildly
miler75733063mi__ler
miles74645073mi__les
milk105028473mi__lk
mill66541483mi__ll
milled94326173mi_lled
miller84625413mi_ller
milles84526563mi_lles
millet84030743mi_llet
mills75435053mi_lls
milo65536103mi__lo
mils66045333mi__ls
milt65455813mi__lt
mime85736403mi__me
minable112315073minable
minae75627723mi_nae
mince95325233mi_nce
mine67256163mi__ne
mingled113612733mingled
mingler104213843mingler
mingles103719003mingles
minke115421763mi_nke
minute83414293minute
miracle1138843miracle
mirage92313653mirage
mire66748233mi__re
mirza16410443mirz_a
mirzas1738173mirzas
misate81222693misate
miscue10412223miscue
mise66043583mi__se
misfile122611553misfile
misled94719313mi_sled
mislie83219153mislie
mispled12310463mispled
misrule939353misrule
missel85216523missel
missile92815403missile
misuse83213643misuse
mite66249413mi__te
mitre75522423mi_tre
mixable18259173mixable
mixible18195093mixible
mizen164815273mi_zen
mizens174610253mizens
mizuna1734303mizuna
mizzens17366123mizzens
mizzling19255443mizzling
mobile103613543mobile
module93011033module
mole66251833m__ole
morale85220553morale
motile83818343motile
mottle84116053mottle
muckle143413583muckle
muddle103414633muddle
muffle14339643muffle
mule65236973m__ule
mumble123614343mumble
muscle10310973muscle
mutule8311423mutule
muzzier17326553muzzier
muzzily2045023muzzily
muzzlers18245203muzzlers
muzzy188410603muzz_y
mycele1335853mycele
myrtle1135733myrtle
nibble103713283nibble
nickle123814483nickle
niggle83612823niggle
nimble103412943nimble
nipple103410373nipple
nozzles15276303nozzles
nuzzled16276393nuzzled
nuzzler15296493nuzzler
nuzzles15298123nuzzles
piazze1634683piazze
pickle144215653pickle
piddle103514913piddle
piffle14418233piffle
pile65649693pi__le
pilule8411123pilule
pimple123512963pimple
pinole83218783pinole
pintle83818263pintle
pizza1538183pizz_a
pizzas1646983pizzas
pizzaz1565443pizzaz
pizzelle1842913pizzelle
pozole1758913pozole
puzzled18286653puzzled
puzzler17276963puzzler
puzzles17318973puzzles
riddle83915713riddle
riffle124210233riffle
rifle85518333ri_fle
rile45650533ri__le
rille55728733ri_lle
rimple103814583rimple
ripple103413913ripple
sickle124418323sickle
sidle65124033si_dle
simile83115633simile
simple104315173simple
single74520603single
sizable1839893sizable
size135630963si_z_e
sizzlers16274753sizzlers
smile74823923smi__le
sozzled16265183sozzled
swizzled2053013swizzled
swizzler1963223swizzler
swizzles1953783swizzles
tazze1339573tazz_e
teazle15329553teazle
tickle124616743tickle
tile45451443ti__le
tingle74319053tingle
tinkle103714453tinkle
tipple103411913tipple
title54721073ti_tle
tittle63613323tittle
tizzies15287893tizzies
tizzy16548893tizz_y
touzle15429003touzle
unmuzzle1842303unmuzzle
viable111613773viable
vile76139803vi__le
virile9313433virile
vittle94711753vittle
vizsla1833703vizsla
widdle113814843widdle
wiggle113713013wiggle
wile75944373wi__le
wimble133211923wimble
wimple133611363wimple
windle104617953windle
winkle133812833winkle
wintle94014603wintle
winze175014853winz_e
wizzen17387203wizzen
wizzes175110773wizzes

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163006.06318590.8
3Display Results3003000.1102727.3
 (SQL Overall)1786913006.31328305.2
 
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.