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

436 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
goglets937978(None) 
giglets93211551giglets
goblets103210181goblets
goglet84618581goglet_
guglets9369691guglets
aglets73915682_aglets
aiglets84012912aiglets
bogles95020832bogle_s
collets93517902collets
doglegs1034782doglegs
eaglets84111662eaglets
fogless1138192fogless
froglets1235262froglets
gallets83517402gallets
giblets103210422giblets
giglet83920272giglet_
giglots9367862giglots
gimlets10338432gimlets
gobbets12327642gobbets
goblet93219482goblet_
godets8410932go_dets
godless938402godless
gogglers11276712gogglers
goggles103510792goggle_s
golems939322go_lems
gorgets94711782gorgets
guglet84018222guglet_
gullets84013712gullets
gurglets10355542gurglets
hoggets12498322hoggets
howlets13329222howlets
loggets9378912loggets
oglers74313182_oglers
ogles65223182_ogle_s
owlets93110392_owlets
piglets103311792piglets
reglets83512982reglets
toilets74112912toilets
tonlets73212502tonlets
wiglets113411422wiglets
aglet65534143_aglet_
aiglet74224193aiglet_
aigrets82810533aigrets
amulets939923amulets
anglers84014823anglers
angles74426703angle_s
anklets114310413anklets
applets115710063applets
argles75218483argle_s
armlets94610063armlets
auklets11298573auklets
baguets1037483baguets
ballets93719513ballets
begets96215523beg_ets
billets94516153billets
blets75324943__blets
bogarts1047743bogarts
bogeys124510913bog_eys
bogglers12347603bogglers
boggles113411823boggle_s
bogies94724313bogie_s
bogle85821683bogle__
boilers93417063boilers
boles75448603bo_le_s
bolete8519613bo_lete
boletes9316063bo_letes
boleti8413403bo_leti
boletus948643bo_letus
bolts76232113bo_l_ts
bomblets1436023bomblets
bonnets94812803bonnets
booklets14247123booklets
boomlets12246673boomlets
boskets13409473boskets
boules84925973boule_s
bowlegs13366823bowlegs
bowlers123715783bowlers
bowless123310313bowless
buglers105115323buglers
bugles94822443bugle_s
bullets93516393bullets
cablets114216343cablets
callets93821703callets
camlets114314623camlets
caplets114914523caplets
chalets122813473chalets
coalers94419353coalers
cobles104622883coble_s
coilers93619903coilers
coles76055063co_le_s
coleus86818273co_leus
collects12279783collects
collet84030363collet_
colts76633293co_l_ts
comets105823583co_mets
coolers93522493coolers
coolest9318643coolest
coplots11511593coplots
coquets18399893coquets
cornets94820573cornets
corsets94819803corsets
corslets1038273corslets
corvets124715023corvets
cosets85824403co_sets
cossets95014283cossets
coulees9315513coulees
couplets12389873couplets
covets114819643co_vets
coxless1637743coxless
culets85518513_culets
cullets94015613cullets
cutlets94113653cutlets
cygnets1333813cygnets
diglots9299503diglots
dockets144412243dockets
doges75630163dog_e_s
dogeys115510663dog_eys
doggers104413433doggers
dogies85022253dogie_s
dogleg936323dogle_g
dogsleds1142913dogsleds
doles67843753do_le_s
dolts65626313do_l_ts
dongles93212873dongle_s
doolees83711613doolees
doublets11257363doublets
doyleys14384923doyleys
droplets1136063droplets
eagles73819163eagle_s
eaglet73722583eaglet_
eggless935663eggless
egoless836983ego_less
egrets72712243_egrets
engluts834533engluts
eyelets1057523eyelets
filets94718953_filets
fillets103414753fillets
fogeys13509263fog_eys
foggers124112013foggers
fogies104118063fogie_s
foleys123810463fo_leys
folles93820473folle_s
forgets113813793forgets
foulest10313313foulest
fowlers133411203fowlers
froglet11310063froglet_
fugles104715783fugle_s
gables94222333gable_s
gadgets10348683gadgets
gagers84021333gag_ers
gages74529973gag_e_s
gaggers103413663gaggers
gaggles103512593gaggle_s
galeas74618513g_aleas
gales65442483g_ale_s
gallet73630853gallet_
galleta8399653galleta
galletas9308133galletas
galleys11369713galleys
gannets83811443gannets
gantlets9308903gantlets
gaolers83511563gaolers
gapless10349993gapless
gargets94614573gargets
garglers10418263garglers
gargles94214893gargle_s
garnets84115413garnets
garrets84413623garrets
gaskets12348153gaskets
gasless8319013gasless
gaults74112783gaul_ts
gelees74116263g_elees
gelts65924613g_el_ts
genets75716663g_enets
gets55442483__g_ets
gibbets12417723gibbets
giblet93418893giblet_
gigglers11297403gigglers
giggles103312933giggle_s
giglot84013133giglot_
gigots83911953gig_ots
gigues8129003gigue_s
gillers84216903gillers
gillnets934733gillnets
gilts64924263g_il_ts
gimlet93716663gimlet_
gleds75417893__gleds
glees65027593__glees
gleets75315053g_leets
glens66519853__glens
gleys96514853__gleys
gluts66120133__gluts
goaled85014363goale_d
goalies8316023goalies
goalless935723goalless
goals65521293goal__s
goatees82710443goatees
goats65527303go__ats
gobbet114214443gobbet_
gobblers13308343gobblers
gobbles123512583gobble_s
gobies95418063gobie_s
goblins1039243goblins
goboes95914443goboe_s
goddess1035263goddess
godet7530043go_det_
godliest1039453godliest
godwits1234133godwits
goers65520253go__ers
goes55644093go__e_s
gofers104711513go_fers
goffers14409213goffers
goggle94511573goggle__
goggled11348953goggle_d
goggler10379323goggle_r
goggliest1234063goggliest
gogos77516523gog__os
goiters84014443goiters
goldest92411173goldest
golds75421313go_l_ds
golem8416113go_le_m
golfers114410083golfers
golfs95616103go_l_fs
gomers94116883go_mers
gonefs10439873go_nefs
goners74420173go_ners
goobers10219623goobers
googlies1086763googlies
gooiest82813883gooiest
gooneys11407073gooneys
gooses75723063goose_s
gophers1338983gophers
gores65740373go_re_s
gorgers94813643gorgers
gorges85321893gorge_s
gorget87123863gorget_
gorhens1137183gorhens
goriest82218743goriest
gormless11235443gormless
gorses74723293gorse_s
gospels1035593gospels
gougers94911763gougers
gouges86318693gouge_s
gourmets1144153gourmets
gouts64826173go__uts
goxes135018263go_xe_s
greets75117423g_reets
grivets11357973grivets
grommets13234663grommets
growlers12327093growlers
guggles103410543guggle_s
guiles73919283guile_s
guilts74111233guil_ts
gules64831043g_ule_s
gullet74924833gullet_
gulleys11438523gulleys
gumless10228273gumless
gunless8299633gunless
gurgles94312873gurgle_s
gurglet94412033gurglet_
gurnets84010793gurnets
gussets837443gussets
gutless82610713gutless
hamlets123211403hamlets
haslets102510863haslets
hoggers124512483hoggers
hogget114715763hogget_
hognuts1134183hognuts
holes84748653ho_le_s
hollers103818233hollers
holts85627913ho_l_ts
hooklets15217203hooklets
hornets104113553hornets
howlers133312353howlers
howlet123518343howlet_
hoyles12315013hoyle_s
ingles74420873ingle_s
inlets63915573_inlets
islets64513083_islets
jagless1537103jagless
jobless16237563jobless
joggers164110693joggers
jogglers17356883jogglers
joggles164410413joggle_s
joles125230833jo_le_s
jolts125018883jo_l_ts
joules134116823joule_s
joyless17226513joyless
keglers12277773keglers
kinglets13318583kinglets
legless838013legless
lets47147943___lets
lockets134612203lockets
loges66534203log_e_s
loggats9286453loggats
loggers94616133loggers
logiest82515543logiest
lollers72713793lollers
maglevs1334693maglevs
magnets10311143magnets
mallets93318493mallets
millets94216843millets
moilers93615203moilers
moles74747923mo_le_s
molest85022743mo_lest
molests93311563mo_lests
molts76032093mo_l_ts
mooleys1236863mooleys
moonlets10247473moonlets
moppets13307163moppets
motets84216193mo_tets
motleys1235683motleys
moults84713703moul_ts
mullets93614783mullets
neglects1144383neglects
nobles83319723noble_s
noblest93613563noblest
nonets64118703no_nets
nuggets936383nuggets
nutlets74111253nutlets
objets15125323_objets
octets839403_octets
ogees65119143_og_ees
ogle56325053_ogle__
ogled75915963_ogle_d
ogler65917443_ogle_r
ogres65818633_ogre_s
ogress7529503_ogress
oilers64721193_oilers
oleos55419683_o_leos
oles46453473_o_le_s
omelets938333omelets
onsets64013543_onsets
oodles73517183oodle_s
orles55326213_orle_s
outlets73616363outlets
owlet83324463_owlet_
palets85122313_palets
pallets93919303pallets
pegless1038053pegless
pellets94014783pellets
piglet93420923piglet_
piolets93513193piolets
pockets154612253pockets
poets76024443po__ets
pogeys124110353pog_eys
pogies94123543pogie_s
poleis86018353po_leis
polers84225643po_lers
poles75351003po_le_s
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
poolers94217423poolers
poppets10338853poppets
possets94212773possets
poults84613483poul_ts
pullets94015163pullets
reflets103513153reflets
reglet73724233reglet_
regrets83212923regrets
relets64025673_relets
riblets93412553riblets
rillets74216153rillets
ringlets92910243ringlets
robles85321693roble_s
rochets124213473rochets
rockets134615363rockets
rodless8310073rodless
rogers74517913rog_ers
rogues74617673rogue_s
roles56747983ro_le_s
rollers73117473rollers
rootlets8308653rootlets
roquets16398943roquets
rosets65819953ro_sets
runlets73310773runlets
sallets73719653sallets
samlets93813553samlets
signets83311503signets
singlets93611473singlets
smogless1134053smogless
sniglets9276813sniglets
sockets134012983sockets
socles8418453socle_s
soles55547923so_le_s
soleus64615613so_leus
songless9218823songless
sonless72612613sonless
sonnets74211993sonnets
sorbets93012513sorbets
soviets1087293soviets
stylets10369213stylets
sublets92616703sublets
tablets94714383tablets
toeless72612393toeless
togglers10276953togglers
toggles93710973toggle_s
togues76014243togue_s
toilers74116263toilers
toiles63923513toile_s
toilet66228093toilet_
toles55147133to_le_s
tollers73217463tollers
tonlet62924703tonlet_
toolers74416503toolers
topless92511123topless
toquets16367863toquets
townlets1134773townlets
toyless10268713toyless
tugless837383tugless
valets93715623_valets
varlets10411573varlets
violets102210003violets
voguers11356693voguers
vogues104011923vogue_s
voiles94616443voile_s
voles86234043vo_le_s
volleys13316643volleys
voltes94915583vo_ltes
volts85421293vo_l_ts
vowless13246603vowless
wallets103914833wallets
wigless11359673wigless
wiglet105519153wiglet_
willets104414323willets
winglets12299593winglets
woolens10398843woolens
woolers104214023woolers
worsets105512843worsets
yodlers11298923yodlers
yodles103714333yodle_s
yogees10510633yog_ees
yogurts1142983yogurts
yowlers13328923yowlers
zoogleas1843373zoogleas

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 Filter1786911340270.420425454.8
2DLD Change Limit1340274365.73623365.9
3Display Results4364360.1562794.9
 (SQL Overall)1786914366.31228309.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.