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

320 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
guttlers930692(None) 
gutters83715501gutt_ers
guttler8369161guttler_
guttles83011931guttle_s
battlers104110972battlers
bottlers103810012bottlers
bustlers104210612bustlers
butlers94518052bu_tlers
butters94521712butt_ers
cutlers94216992cu_tlers
cutters94218952cutt_ers
cuttles93613922cuttle_s
getters84216092gett_ers
gustless9287682gustless
gutless82610712gu_tless
gutter73817702gutt_er_
guttery11427752gutt_ery
guttier83911102guttier_
guttle74111972guttle__
guttled9378992guttle_d
guzzlers17274862guzzlers
hustlers11349202hustlers
mottlers10388182mottlers
mutters94117132mutt_ers
nettlers8307512nettlers
nutters74215422nutt_ers
putters94219182putt_ers
puttiers10288012puttiers
rattlers83510292rattlers
rustlers8339852rustlers
settlers8289022settlers
shuttlers1254122shuttlers
sutlers73116972su_tlers
tattlers8369692tattlers
turtlers8258202turtlers
utters63817112_utt_ers
abutters1056983abutt_ers
antlers74014743_antlers
batters94626013batt_ers
battler94113383battler_
battles94517683battle_s
beetlers1037393beetlers
betters94422093bett_ers
bitters94920353bitt_ers
bottler94211883bottler_
bottles94216273bottle_s
bubblers11448943bubblers
bucklers16349503bucklers
buglers105115323bu_glers
bumblers143710733bumblers
bundlers11399183bundlers
bunglers11398483bunglers
bunters94717113bunt_ers
burblers12399263burblers
burlers94120273bu_rlers
busters94724123bust_ers
bustiers103810043bustiers
bustler94012563bustler_
bustles93816323bustle_s
butchers153710183butchers
butler84220033bu_tler_
butlery12369423bu_tlery
butles84423913bu_tle_s
butter84724233butt_er_
buttery124311193butt_ery
buttes84822563butt_e_s
butties93217953buttie_s
buttoners1145703buttoners
buttress1035883buttress
clutters103210343clutt_ers
cotters94323433cott_ers
cottiers10399153cottiers
cuddlers12388383cuddlers
cuittles1045903cuittle_s
cullers93418843cu_llers
cupelers1266733cupelers
curdlers11368493curdlers
curlers94218063cu_rlers
cutler84718033cu_tler_
cutlery12448393cu_tlery
cutlets94113653cu_tlets
cutovers1335113cutovers
cutter84520993cutt_er_
cutties93118843cuttie_s
cuttle84113893cuttle__
cuttled10319933cuttle_d
dotters83715973dott_ers
dottles83912283dottle_s
ductless11196313ductless
duelers83412053du_elers
duellers9268223duellers
dusters84918353dust_ers
dustless9328343dustless
fetters103517903fett_ers
fettles103912733fettle_s
fitters104517743fitt_ers
flutters114010813flutt_ers
footlers113910793footlers
fuelers103912393fu_elers
fuellers11277983fuellers
fullers103817373fu_llers
fumblers15318713fumblers
furlers104214223fu_rlers
furthers1436493furthers
gabblers134110083gabblers
gaiters83516533gait_ers
gamblers13369733gamblers
gantlets9308903gantlets
gaolers83511563g_aolers
garblers113810283garblers
garglers10418263garglers
garters84218223gart_ers
gasters85624283gast_ers
gateless9279953gateless
gaters74728633g_at_ers
gathers114315063g_athers
gauntlets1042873gauntlets
gentler8378953gentler_
gentles83714343gentle_s
getter74117613gett_er_
giftless1245173giftless
gigglers11297393gigglers
gillers84216893g_illers
girdlers10195403girdlers
gittern8337503gitt_ern
gitterns9326563gitt_erns
glitters93710543glitters
gobblers13308343gobblers
gogglers11276713gogglers
goiters84014433goit_ers
graters85419733grat_ers
grillers93810803grillers
gritters94210633gritters
growlers12327093growlers
gruelers936173gruelers
gruellers1034183gruellers
grumblers14245023grumblers
grunters9359023grunt_ers
gruntles9287233gruntle_s
guarders1035873guarders
guessers9174893guessers
guggles103410543guggle_s
guglets9369693gu_glets
guiders94111103gu_iders
guilders1035513guilders
guiles73919283gu_ile_s
guiltless1043023guiltless
guitars8116853guit_ars
gules64831043gu__le_s
gullets84013713gu_llets
gulleys11438523gu_lleys
gulpers10299003gu_lpers
gumless10228273gu_mless
gummers123712193gu_mmers
gumtrees1143873gumtrees
gunless8299633gu_nless
gunners83111723gu_nners
gurgles94312873gurgle_s
gurglets10355543gurglets
gushers113512503gu_shers
gustier83813863gustier_
gustoes879873gustoe_s
gutsier8389823gutsier_
guttae73210583guttae__
gutted84716363gutt_e_d
guttered10259153gutt_ered
guttiest92311223guttiest
guttling1037293guttling
guzzler16286563guzzler_
guzzles16328043guzzle_s
hatters104221523hatt_ers
hitters104717583hitt_ers
hostlers113310483hostlers
huddlers13337633huddlers
hullers103616263hu_llers
humblers15379803humblers
hunters103915723hunt_ers
hurdlers12337493hurdlers
hurlers103714323hu_rlers
hurters103413633hurt_ers
hurtles103913753hurtle_s
hurtless11307783hurtless
hustler103410753hustler_
hustles103414173hustle_s
jitters144314463jitt_ers
jostlers15357683jostlers
jotters143413803jott_ers
jugglers17366523jugglers
jumblers19358323jumblers
justers143815723just_ers
justles143311433justle_s
jutties143814003juttie_s
kettles113411613kettle_s
kittler11338163kittler_
kittles113012493kittle_s
letters73819853lett_ers
litters73422563litt_ers
littler7348553littler_
littles73212783little_s
lotters73921063lott_ers
lullers73213353lu_llers
lusters73921433lust_ers
luthiers1135163luthiers
matters94421753matt_ers
mettles94115023mettle_s
mottler94410343mottler_
mottles93415803mottle_s
muddlers12428803muddlers
mufflers16316003mufflers
mullers93217303mu_llers
mumblers14328763mumblers
murthers1336543murthers
musters94522493must_ers
mutter84418883mutt_er_
mutterers11247373mutterers
mutules9311843mutule_s
muzzlers18245203muzzlers
natters73718063natt_ers
nestlers8359223nestlers
netters73618583nett_ers
nettler7349503nettler_
nettles73214083nettle_s
nutlets74111253nu_tlets
nutter63918053nutt_er_
nuttier73112023nuttier_
nuzzlers16244753nuzzlers
ostlers72911203_ostlers
otters64021513_ott_ers
ousters74122773oust_ers
outbless1037963outbless
outdoers937503outdoers
outers64230163ou_t_ers
outlets73616363ou_tlets
outliers82610673outliers
outsteers936033outsteers
outtells896853outtells
outtowers1244763outtowers
patters94825193patt_ers
petters93722363pett_ers
pettles93916483pettle_s
potters94024343pott_ers
pottles93816983pottle_s
prattlers11195323prattlers
puddlers12298683puddlers
pulers83820283pu__lers
pullers93618483pu_llers
punters93617033punt_ers
purflers13216963purflers
puttees93612913putt_ees
putter83921443putt_er_
putterers11238363putterers
puttier93314503puttier_
putties94420023puttie_s
puttyless1442013puttyless
puzzlers18295143puzzlers
quellers17237533quellers
quilters17228433quilters
quitters17238523quitters
quoters16369253quot_ers
ratters74422473ratt_ers
rattler74012743rattler_
rattles73217303rattle_s
reutters8138563reutt_ers
ritters74020613ritt_ers
rotters74421393rott_ers
rufflers14347193rufflers
rulers64317093ru__lers
rumblers123610743rumblers
rustler73512343rustler_
rustles73416413rustle_s
rustless83510233rustless
ruthless1135413ruthless
rutiles74315843rutile_s
ruttier73412283ruttier_
scutters103311013scutt_ers
scuttles1056503scuttle_s
setters73822063sett_ers
settler73410653settler_
settles73916003settle_s
settlors8255003settlors
shutters113611333shutt_ers
shuttler1164893shuttler_
shuttles1136543shuttle_s
sitters74221543sitt_ers
sputters104012863sputt_ers
stutters83210463stutters
stylers10359343_stylers
subtler92910843subtler_
sucklers14379963sucklers
suiters73618873suit_ers
sutler63718393su_tler_
suttees74114063sutt_ees
talers64628143__talers
tatters74520483tatt_ers
tattler73112213tattler_
tattles73616283tattle_s
tetters74320473tett_ers
tilers63523493__tilers
titters74219613titt_ers
tittles73413253tittle_s
tootlers8289503tootlers
totters74618733tott_ers
tufters10298343tuft_ers
tumblers123110623tumblers
tummlers12295703tummlers
turtler72610323turtler_
turtles72914343turtle_s
tutelars844993tutelars
tutoyers1133303tutoyers
tutties73216473tuttie_s
utter54218763_utt_er_
utterers8218653_utterers
vetters104016313vett_ers
vittles103211113vittle_s
wattles103814073wattle_s
wattless11268723wattless
wetters103817753wett_ers
whittlers1594333whittlers
wuthers133711523wu_thers
yatters103914623yatt_ers

Search took 10 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 Limit1461623208.75016704.2
3Display Results3203200.1232601.6
 (SQL Overall)1786913209.02919790.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.