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

351 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
juggler1641887(None) 
joggler16398831joggler
juggle154310281juggle_
juggled17348651juggled
jugglers17366521jugglers
jugglery20303811jugglery
juggles164510841juggles
boggler113910082boggler
bugger104418722bugg_er
buggier113611342buggier
bugler94717722bu_gler
bungler104611482bungler
fuggier12348962fuggier
giggler101029882giggler
goggler10379322goggler
guggle94110432guggle_
guggled11338562guggled
guggles103410542guggles
haggler12328932haggler
higgler12369802higgler
hugger114713122hugg_er
jagger154016002jagg_er
jaggier16339182jaggier
jangler153811832jangler
jigger155313052jigg_er
jiggier16377822jiggier
jiggle153811992jiggle_
jiggled17358842jiggled
jiggles164111432jiggles
jigglier1754092jigglier
jingler154311082jingler
jogger154713162jogg_er
joggle154010352joggle_
joggled17398432joggled
jogglers17356882jogglers
joggles164410412joggles
judger154411442judg_er
jugged163813932jugg_ed
jugular1534512jugular
jumbler183910272jumbler
jungle144012652jungle_
jungled16349642jungled
jungles154112542jungles
junglier1644302junglier
lugger83916552lugg_er
mugger103914702mugg_er
muggier11288942muggier
niggler93610292niggler
puggier11309382puggier
rugger84414512rugg_er
smuggler12244522smuggler
toggler9399192toggler
tugger84013102tugg_er
vuggier12296812vuggier
wiggler123110762wiggler
agger76420893_agg_er
angler74017863_angler
auger64922473au_g_er
augurer8136343augurer
bagger104619203bagg_er
baggier113611643baggier
bigger104315063bigg_er
boggier113711583boggier
boggle104511943boggle_
boggled12409003boggled
bogglers12347603bogglers
boggles113411823boggles
bubbler103611783bubbler
buckler154112033buckler
budger104617703budg_er
bugged114318403bugg_ed
buggers114315663bugg_ers
buggery14367933bugg_ery
buggies114613813buggies
bugle84721943bu_gle_
bugled104918133bu_gled
buglers105115323bu_glers
bugles94822443bu_gles
bulger94917353bulg_er
bulgier103911213bulgier
bumbler134013233bumbler
bundler104011723bundler
bungle97116113bungle_
bungled114112243bungled
bunglers11398483bunglers
bungles104116763bungles
burbler114412423burbler
burger94020793burg_er
burgher1337003burgher
burglar1065533burglar
burgle94815863burgle_
burgled115511423burgled
burgles105615963burgles
burler84723833bu_rler
bustler94012563bustler
butler84220033bu_tler
chugger1445373chugg_er
cuddler113810743cuddler
cudgeler1253313cudgeler
culler84322253cu_ller
cupeler1177483cupeler
curdler103511563curdler
curler85221323cu_rler
cutler84718033cu_tler
dagger95017293dagg_er
daggle93711903daggle_
daggled11329463daggled
daggles103611913daggles
dangler96912813dangler
digger94616083digg_er
dogger95216783dogg_er
doggier103810943doggier
druggier11134833druggier
dueler74213683du_eler
dueller8329833dueller
duller74017703du_ller
dungier9368583dungier
egger74414403_egg_er
faggier12309843faggier
fogger114414773fogg_er
foggier12349913foggier
fueler94313933fu_eler
fueller10279963fueller
fugged124615383fugg_ed
fugle94915543fu_gle_
fugled114813693fu_gled
fugles104715783fu_gles
fuller94220383fu_ller
fumbler143610813fumbler
furler93616403fu_rler
gagger95016513gagg_er
gaggle93412623gaggle_
gaggled11359913gaggled
gaggles103512593gaggles
gargler93710263gargler
giggle94313513giggle_
giggled114010073giggled
gigglers11297393gigglers
giggles103312933giggles
gigglier1154323gigglier
goggle94511573goggle_
goggled11348953goggled
gogglers11276713gogglers
goggles103510793goggles
gogglier1153923gogglier
guglet84018223gu_glet
gurgle83912473gurgle_
gurgled10399123gurgled
gurgles94312873gurgles
gurglet94412033gurglet
guttler8369163guttler
guzzler16286563guzzler
haggle113511983haggle_
haggled13359283haggled
hagglers13326623hagglers
haggles123312483haggles
higgle113811743higgle_
higgled13339073higgled
higglers13297223higglers
higgles123911803higgles
hogger114615083hogg_er
huddler12379423huddler
huger94914873hu_g_er
hugged124113643hugg_ed
huggers124211593hugg_ers
huller93919103hu_ller
humbler143411943humbler
hunger104015203hung_er
hurdler113610003hurdler
hurler94717223hu_rler
hustler103410753hustler
jaeger14397193jaeg_er
jager134318133j_ag_er
jagged164115353jagg_ed
jaggeder1842783jaggeder
jaggers164012893jagg_ers
jaggery19336903jagg_ery
jagghery2351803jagghery
jaggies163311083jaggies
jailer134316683j_ailer
jangle144416293jangle_
jangled164111563jangled
janglers16319373janglers
jangles154015683jangles
janglier1656113janglier
jeweler1735053jeweler
jigged164412773jigg_ed
jiggers164010173jigg_ers
jiggly18378713jiggl_y
jingle143815223jingle_
jingled164111063jingled
jinglers16408753jinglers
jingles153816383jingles
jinglier1655223jinglier
jogged166015923jogg_ed
joggers164110693jogg_ers
jongleur1642023jongleur
jostler14288223jostler
jubile152910253jubile_
jubilee16298293jubilee
jubiles16289373jubiles
judder15439423ju_dder
judge144714153judg_e_
judged165911253judg_ed
judgers16369043judg_ers
judges153713453judg_es
jugal135612403jugal__
jugate14379463jugate_
jugging172910723jugging
juggleries1942803juggleries
juggling18225603juggling
jugula1434983jugul_a
jugulars1643233jugulars
jugulum1742503jugulum
juicer1536283ju_icer
juicier1635463juicier
julep14310533ju__lep
jumble174012653jumble_
jumbled19379963jumbled
jumblers19358323jumblers
jumbles183013323jumbles
jumper173612373ju_mper
jumpier18317943jumpier
jungly17407693jungl_y
juniper1634023juniper
junker174213653ju_nker
junkier18339493junkier
juster134617013ju_ster
justle133211583justle_
justled15338093justled
justles143311433justles
kegeler1245493kegeler
kegger12388063kegg_er
kegler11398233_kegler
lagger85919833lagg_er
leggier9368233leggier
logger86420003logg_er
loggier93811143loggier
luger65322083lu_g_er
lugged94417053lugg_ed
luggers93713483lugg_ers
luggie8318903luggie_
luggies93011213luggies
luller63415483lu_ller
lunger75720413lung_er
mangler103215643mangler
miggle104012113miggle_
miggles113512033miggles
mingler104213833mingler
muddler113411623muddler
muffler15398343muffler
muggar10316443mugg_ar
mugged114113833mugg_ed
muggee103612833mugg_ee
muggees11338883muggees
muggers113611933mugg_ers
muggur10325593mugg_ur
muller83820353mu_ller
mumbler133510913mumbler
muzzler17257943muzzler
nagger84016123nagg_er
naggier9309153naggier
nigger89713573nigg_er
niggle83612823niggle_
niggled10319203niggled
nigglers10307243nigglers
niggles93512203niggles
nigglier1044843nigglier
nudger85111633nudg_er
nugget8311723nugg_et
nuzzler15296493nuzzler
ogler65917443__ogler
piggier113510003piggier
plugger11378423plugg_er
puddler112910753puddler
pudgier11377723pudgier
pugged114314523pugg_ed
puggree11176113puggree
puler74826623pu__ler
puller83820813pu_ller
pungle94413573pungle_
pungled114210083pungled
pungles104013713pungles
purfler12248733purfler
purger94717233purg_er
purpler11289263purpler
puzzler17276963puzzler
quaggier1933853quaggier
queller16289293queller
raggle83712883raggle_
raggles93813283raggles
regaler83814623regaler
rejuggle17122553rejuggle_
rejuggled1982113rejuggled
rejuggles18122423rejuggles
rigger85616713rigg_er
ruffler13369723ruffler
rugged94215373rugg_ed
ruggeder1142723ruggeder
ruggers94612313rugg_ers
ruler54923343ru__ler
rumbler113514113rumbler
rustler73512343rustler
sagger84321073sagg_er
saggier92912063saggier
slugger93610673slugg_er
smugger11327053smugg_er
smuggle11265013smuggle_
smuggled13254213smuggled
smugglers13263433smugglers
smuggles12225443smuggles
sniggler10396113sniggler
snugger9318313snugg_er
snuggle9275713snuggle_
snuggled11234953snuggled
snuggles10306133snuggles
soggier93410883soggier
struggler11264553struggler
subtler92910843subtler
suckler133413093suckler
sugarer837323sugarer
suppler1148433suppler
surger74320093surg_er
sutler63718393su_tler
tagger84017693tagg_er
tangler83515073tangler
tingler83613323tingler
toggle83810873toggle_
toggled10428653toggled
togglers10276953togglers
toggles93710973toggles
tugged93813523tugg_ed
tuggers93711443tugg_ers
tumbler113412823tumbler
tummler11266613tummler
turtler72610323turtler
uglier748953_uglier
urger64116473_urg_er
wagger113616013wagg_er
waggle113612303waggle_
waggled13389363waggled
waggles123812003waggles
wagglier1344323wagglier
wangler113312653wangler
wiggier12418863wiggier
wiggle113713013wiggle_
wiggled13299603wiggled
wigglers13257203wigglers
wiggles123312463wiggles
wigglier1354453wigglier
wriggler13295263wriggler

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.1531167915.0
2DLD Change Limit1340273516.84619577.4
3Display Results3513510.1232853.7
 (SQL Overall)1786913517.12225090.0
 
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.