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

461 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
miggle10401211(None) 
giggle94313511giggle
higgle113811741higgle
jiggle153811991jiggle
miggles113512031miggles
mingle93518781mingle
niggle83612821niggle
wiggle113713011wiggle
biggie103810932biggie
boggle104511942boggle
daggle93711902daggle
dingle84317072dingle
gaggle93412622gaggle
giggled114010072giggled
giggler101029882giggler
giggles103312932giggles
giggly12518702giggly
goggle94511572goggle
guggle94110432guggle
haggle113511982haggle
higgled13339072higgled
higgler12369802higgler
higgles123911802higgles
ingle64120432_ingle
jiggled17358842jiggled
jiggles164111432jiggles
jiggly18378712jiggly
jingle143815222jingle
joggle154010352joggle
juggle154310282juggle
ligule74010832ligule
mangle93921322mangle
mickle143715132mickle
middle103414982middle
midge95016542midg_e
migg85716802migg__
miggs96311372migg_s
mile66352572mi__le
mille75029132mi_lle
mingled113612732mingled
mingler104213842mingler
mingles103719002mingles
mizzle16279992mizzle
moggie103210102moggie
muggee103612832muggee
niggled10319202niggled
niggler93610292niggler
niggles93512202niggles
niggly11418912niggly
piggie103210772piggie
raggle83712882raggle
single74520602single
smuggle11265012smuggle
sniggle9316832sniggle
tingle74319052tingle
toggle83810872toggle
waggle113612302waggle
wiggled13299602wiggled
wiggler123110762wiggler
wiggles123312462wiggles
wiggly14559682wiggly
wriggle12316212wriggle
aggie73415013_aggie
agile65122263_agile
aiglet74224193ai_glet
aisle55223193ai_sle
amiable11312033amiable
angle64528873_angle
argle65421563_argle
argyle1066063argyle
atingle848253atingle
baggie102912193baggie
bangle94018953bangle
beagle93612593beagle
bemingle1346103bemingle
bible95119423bi_ble
bigeye1236643bigeye
bigger104315063bigger
biggies113813523biggies
biggin103710603biggin
biggy124413133bigg_y
bigly114814753bi_gly
bile66147183bi__le
bilge87618913bilg_e
bindle94516263bindle
binge85125513bing_e
birle75023633bi_rle
boggled12409003boggled
boggler113910083boggler
boggles113411823boggles
bogle85821683_bogle
bugle84721943_bugle
bungle97116113bungle
burgle94815863burgle
cicale10314503cicale
circle1039703circle
citole8311503citole
comingle1336053comingle
cringle103010353cringle
daggled11329463daggled
daggles103611913daggles
dangle84119303dangle
dibble114013843dibble
diddle94915213diddle
digged104314653digged
digger94616083digger
dimple113512793dimple
dindle84417223dindle
dinge75627303ding_e
dingles93818323dingles
dipole91112853dipole
dirge75117073dirg_e
doggie93910893doggie
dongle83612493dongle
draggle1056103draggle
eagle64219483_eagle
emigre937053emi_gre
fickle153912973fickle
fiddle113613383fiddle
fidge104516053fidg_e
figged124013893figged
figure10258833figure
file75446643fi__le
fille84327403fi_lle
fimble133611753fimble
finagle11238313finagle
finale94116763finale
fipple13329063fipple
fizzle17369713fizzle
fugle94915543_fugle
gaggled11359913gaggled
gaggles103512593gaggles
gale56347323__gale
gargle84215463gargle
gigged104112293gigged
gigglers11297393gigglers
gigglier1154323gigglier
gighe10139733gi_ghe
giglet83920273gi_glet
gigolo836533gigolo
gigue71210673gi_gue
girdle82110463girdle
goggled11348953goggled
goggler10379323goggler
goggles103510793goggles
goggly12337053goggly
guggled11338563guggled
guggles103410543guggles
gurgle83912473gurgle
haggled13359283haggled
haggler12328933haggler
haggles123312483haggles
higglers13297223higglers
highly1636823highly
hinge95323443hing_e
hirple11158973hirple
hirsle9159573hirsle
idle55423763_i_dle
igg57116793_igg__
igged86012763_igged
iggs66612673_igg_s
iglu510814783_i_glu
image81411293imag_e
immingle13124323immingle
impale102811663impale
ingles74420873_ingles
inkle94515833_inkle
isle45121703_i_sle
istle52214713_istle
ixtle12168013_ixtle
jangle144416293jangle
jigged164412773jigged
jigger155313053jigger
jiggier16377823jiggier
jigglier1754093jigglier
jiggy17549143jigg_y
jingled164111063jingled
jingler154311093jingler
jingles153816383jingles
jingly174111933jingly
joggled17398433joggled
joggler16398833joggler
joggles164410413joggles
juggled17348653juggled
juggler16418873juggler
juggles164510843juggles
jungle144012653jungle
kibble143910953kibble
kindle114414233kindle
kinglet123114043kinglet
kingly143511303kingly
kirtle10309473kirtle
kittle104012173kittle
liable81415813liable
liege65314433lieg_e
ligase7259913ligase
ligate72519243ligate
ligula7359673ligula
ligulae8308753ligulae
ligules82210913ligules
ligure7279473ligure
lisle53916723li_sle
little63312163little
loggie84011993loggie
luggie8318903luggie
mackle143716433mackle
macle96127003m_acle
macule104115273macule
mage75739123m_ag_e
maggot10311703maggot
magilp1137613magilp
maglev1237023m_aglev
magpie1139093magpie
maigre9309163maigre
maile75232223m_aile
male66052293m__ale
malgre9299303malgre
mange84930183mang_e
mangel94017533mangel
mangled113615253mangled
mangler103215643mangler
mangles104021463mangles
mantle84420923mantle
maple95521143m_aple
marble104219103marble
marge85328333marg_e
maugre9308973maugre
meagre9349323meagre
measle83513223measle
meddle103312763meddle
megilp1135833megilp
meikle1236653meikle
merge84523683merg_e
mergee94018133mergee
merle75824373m_erle
mettle83815723mettle
miaul71612123miaul_
miauled1036663miauled
miauls8178713miauls
mice87442233mi__ce
micell1098193micell
micelle1178343micelle
miche126219243mi_che
mickler153310233mickler
mickles153415003mickles
middled123311893middled
middler112712273middler
middles113415303middles
midges103516473midges
midget103718443midget
midgut103510053midgut
midleg1038553mi_dleg
midsole1037813midsole
mig65646083mi_g__
might113827083mi_ght
mights123516253mights
mighty154310203mighty
mignon937953mignon
migrate101314163migrate
migs76935323mi_g_s
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
mingier103815293mingier
minglers113011293minglers
mingy115520183ming_y
minke115421763mi_nke
minute83414293minute
miracle1138843miracle
mirage92313653mirage
mire66748233mi__re
misate81222693misate
miscue10412223miscue
mise66043583mi__se
misfile122611553misfile
misgave13298283misgave
misgive13339033misgive
misgrew1335523misgrew
misled94719313mi_sled
mislie83219153mislie
mispled12310463mispled
misrule939353misrule
missel85216523missel
missile92815403missile
misuse83213643misuse
mite66249413mi__te
mitre75522423mi_tre
mixable18259173mixable
mixible18195093mixible
mizzled18327633mizzled
mizzles17329493mizzles
mizzly19256103mizzly
mobile103613543mobile
module93011033module
mogged115215393mogged
moggies113111723moggies
moggy125212163mogg_y
mogul8310213mogul_
moguled1135923moguled
moguls948553moguls
mole66251833m__ole
mongoe94214983mongoe
morale85220553morale
morgue938113morgue
motile83818343motile
mottle84116053mottle
muckle143413583muckle
muddle103414633muddle
muffle14339643muffle
mugg86316013mugg__
muggar10316443muggar
mugged114113833mugged
muggees11338883muggees
mugger103914703mugger
muggier11288943muggier
muggily1435103muggily
muggs94912323mugg_s
muggur10325593muggur
muggy125612373mugg_y
mule65236973m__ule
mumble123614343mumble
muscle10310973muscle
mutule8311423mutule
muzzle16319393muzzle
mycele1335853mycele
myrtle1135733myrtle
nibble103713283nibble
nickle123814483nickle
nigger89713573nigger
nigglers10307243nigglers
nigglier1044843nigglier
nimble103412943nimble
nipple103410373nipple
ogle56325053__ogle
pickle144215653pickle
piddle103514913piddle
piffle14418233piffle
pigged114214153pigged
piggier113510003piggier
piggies113813483piggies
piggin103111093piggin
piggy124011433pigg_y
piglet93420923pi_glet
pile65649693pi__le
pilule8411123pilule
pimple123512963pimple
pinole83218783pinole
pintle83818263pintle
pizzle16279493pizzle
pungle94413573pungle
raggee84217603raggee
raggles93813283raggles
regale74821453regale
reggae858953reggae
riddle83915713riddle
ridge75018663ridg_e
ridgel8399963ridgel
riffle124210233riffle
rifle85518333ri_fle
rigged94517403rigged
rigger85616713rigger
rile45650533ri__le
rille55728733ri_lle
rimple103814583rimple
ringlet82818173ringlet
ripple103413913ripple
shingle117711273shingle
sickle124418323sickle
sidle65124033si_dle
siege66718443sieg_e
sigil63515503sigil_
sigils73912363sigils
sigla64515203si_gla
signee73617233signee
simile83115633simile
simple104315173simple
singe65731133sing_e
singled93914683singled
singles83520433singles
singlet84120113singlet
singly104015853singly
sizzle14309613sizzle
smidge10378483smidg_e
smile74823923smi__le
smuggled13254213smuggled
smuggler12244523smuggler
smuggles12225443smuggles
sniggled11275743sniggled
sniggler10396113sniggler
sniggles10307313sniggles
snuggle9275713snuggle
squiggle1943173squiggle
swingle113510563swingle
tangle74019953tangle
tickle124616743tickle
tile45451443ti__le
tinge64626613ting_e
tingled93712793tingled
tingler83613333tingler
tingles83818313tingles
tingly103815963tingly
tinkle103714453tinkle
tipple103411913tipple
title54721073ti_tle
tittle63613323tittle
toggled10428653toggled
toggler9399193toggler
toggles93710973toggles
unmingle1145913unmingle
vagile10310543vagile
veggie1136303veggie
viable111613773viable
vigil94313003vigil_
vigils104210193vigils
vile76139803vi__le
virgule1144283virgule
virile9313433virile
vittle94711753vittle
waggled13389363waggled
waggles123812003waggles
waggly14347293waggly
wangle103817503wangle
widdle113814843widdle
wigged124413583wigged
wiggier12418863wiggier
wigglers13257203wigglers
wigglier1354453wigglier
wiggy134510733wigg_y
wiglet105519153wi_glet
wile75944373wi__le
wimble133211923wimble
wimple133611363wimple
windle104617953windle
winglet113115983winglet
winkle133812833winkle
wintle94014603wintle
wriggled14284663wriggled
wriggler13295263wriggler
wriggles13286263wriggles
wriggly15324893wriggly
zigged184110193zigged
zizzle13247313zizzle

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.1261418182.5
2DLD Change Limit1127164616.25018034.6
3Display Results4614610.1533013.1
 (SQL Overall)1786914616.52927368.8
 
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.