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

507 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
goopier10391057(None) 
goofier11339311goofier
gooier73516211goo_ier
goonier83612841goonier
goosier83512561goosier
loopier93711191loopier
boomier113312182boomier
boozier18349012boozier
cooper104221122coop_er
copier103722892_copier
doomier103610122doomier
dopier93515922_dopier
droopier1145572droopier
footier104115112footier
gappier12369842gappier
gimpier12247942gimpier
gloomier1135092gloomier
gloppier1354672gloppier
godlier938892godlier
goober93911742goo_ber
goodie83613992goodie_
goodies93516992goodies
goodlier1035792goodlier
goonie73615562goonie_
goonies83618332goonies
goopiest112710552goopiest
gopher1239182g_opher
gorier73719372g_orier
gorsier83811072gorsier
goutier82612352goutier
grapier103712602grapier
gripier103210322gripier
grodier939672grodier
groovier1233792groovier
groper94517252grop_er
gulpier1046952gulpier
hoodier113812972hoodier
hookier143811672hookier
hooper114518312hoop_er
hootier104915352hootier
hoppier143110702hoppier
kookier10398282kookier
loonier73312682loonier
looper83817112loop_er
loppier11369722loppier
moodier103212202moodier
moonier93714102moonier
moorier93113072moorier
mopier103914782_mopier
oozier153610252_oozier
rookier114012382rookier
roomier93812242roomier
rootier74915392rootier
ropier84118802_ropier
roupier9319492roupier
snoopier10177272snoopier
soapier93411712soapier
sootier73916612sootier
soppier112711582soppier
soupier93111752soupier
swoopier13175142swoopier
woodier113912062woodier
woolier103612352woolier
woozier19347322woozier
zooier153411232zoo_ier
zootier163611172zootier
adopter1036763adopter
atopies92816433atopies
bloodier1136823bloodier
bloomier1275783bloomier
blooper11358533bloop_er
blowier1248943blowier
boggier113711583boggier
bonier84321993_bonier
bonnier94711313bonnier
boobie104015293boobie_
boobies113718203boobies
boodies103721443boodies
boodler103312003boodler
booger94816553boo_ger
boogie93515993boogie_
boogied11379283boogied
boogies103719013boogies
booker124719193boo_ker
bookie123516003bookie_
bookies133819403bookies
boomer104618513boo_mer
boonies93422483boonies
booster94314553booster
bootie85421163bootie_
booties94124613booties
boozer174815963boo_zer
bopper123813833_bopper
boskier13309173boskier
bossier93712423bossier
bouvier1277433bouvier
boxier154311743_boxier
broodier1157433broodier
broomier1236873broomier
bumpier13359203bumpier
campier133313273campier
chokier1638043chokier
choosier1337173choosier
chopper163611893chopper
choppier17286643choppier
coalier93416183coalier
cobbier133410163cobbier
cockier154013623cockier
collier93618153collier
comfier1439163comfier
compeer133811553compeer
compiler1438373compiler
complier14310253complier
cooer74831013coo__er
cooker124722453coo_ker
cookie123716043cookie_
cookies133719273cookies
cooler84824713coo_ler
coolie83821603coolie_
coolies93824963coolies
cooped114821603coop_ed
coopers114019483coop_ers
coopery143910273coop_ery
cooping123918933cooping
coopted123710763coopted
cooter85128613coo_ter
cootie84223093cootie_
cooties93725733cooties
coper95336093_cop_er
copied114618563_copied
copiers114215963_copiers
copies104130303_copies
copper124321893_copper
copter109822013_copter
corkier133114303corkier
cornier93017093cornier
cosier84423753_cosier
cottier93814173cottier
coupler114713013coupler
courier93617893courier
cowier113616163_cowier
cowpie133511513cowpie_
cowpies143314283cowpies
cozier173315143_cozier
crepier1139743crepier
cropper133312963cropper
crosier94116573crosier
croupier1246883croupier
crozier18369933crozier
cuppier1368323cuppier
diopter1038473diopter
dippier123111393dippier
dodgier10388243dodgier
doggier103810943doggier
doobie94712683doobie_
doobies103915673doobies
doodies94218773doodies
doodler93310153doodler
doolie73916833doolie_
doolies83920713doolies
doozer163910463doo_zer
doozie163910653doozie_
doozies173812723doozies
doper86128393_dop_er
dorkier122810023dorkier
dorper94314573dorp_er
dossier83711693dossier
dotier73917033_dotier
dottier83910923dottier
dowdier12328573dowdier
downier11299703downier
dozier163611633_dozier
droolier936073droolier
dropper12329873dropper
dumpier12409653dumpier
eloper85414153elop_er
flopper14328473flopper
floppier1554633floppier
foamier12339003foamier
foggier12349913foggier
folkier14359043folkier
foodie104413843foodie_
foodies113416753foodies
footer94320773foo_ter
footie94718143footie_
footies103721543footies
footler104011873footler
foozler19397593foozler
forkier144311593forkier
foxier163910033_foxier
fozier183710663_fozier
gabbier12379633gabbier
gambier124711973gambier
gamier93617933g_amier
gammier123711193gammier
gaoler73913573gao_ler
gaper86125123g_ap_er
gasolier935833gasolier
gasper94515543gasp_er
gassier83812573gassier
gaudier938453gaudier
gauzier1735633gauzier
gawkier15326523gawkier
gawper12499693gawp_er
geekier12286393geekier
gemmier12337383gemmier
germier10309543germier
ghostier1235383ghostier
giddier10308723giddier
ginnier8298983ginnier
gipper114215303g_ipper
girlier8289523girlier
glacier103911293glacier
gladier93810993gladier
glarier84112203glarier
glazier17409353glazier
gloater83711013gloater
globbier1334243globbier
glopped13347613glopped
gloried9169513gloried
glories81915913glories
glosser83410813glosser
glossier9358203glossier
glover104513533glo_ver
glower105114933glo_wer
gluier7310263g_luier
glumpier1334873glumpier
goalie7413163goalie_
goalies8316023goalies
gobbler123310023gobbler
gobies95418063g_obies
goer56827103g_o__er
gofer94814283g_o_fer
goffer13409513g_offer
goggler10379323goggler
gogglier1153923gogglier
goiter74116203g_oiter
golder84417603g_older
golfer104411183g_olfer
gomer85220653g_o_mer
gondolier1144723gondolier
goner66025163g_o_ner
gonopore1146383gonopore
goobers10219623goo_bers
goodish1237963goodish
goodmen1135623goodmen
gooey95522863goo__ey
goofed114911383goo_fed
goofiest12289393goofiest
goofily14105353goofily
goofing123510633goofing
googlies1086763googlies
gooiest82813883goo_iest
gooney106612313goo_ney
gooniest93213003gooniest
goop75829483goop___
goops86620963goop__s
goopy115816623goop__y
goose65925903goo_se_
goosed86817033goo_sed
gooses75723053goo_ses
goosey105913513goo_sey
goosiest92911823goosiest
goosing93314083goosing
gophers1338983g_ophers
gopik1257533g_opi_k
gorger86116983g_orger
gospel936533gosp_el
gospeler1173963gospeler
gossiper1164203gossiper
gouger86014363g_ouger
grazier173611133grazier
grimier103210433grimier
griper94114613grip_er
gripper124410713gripper
grippier1355203grippier
groaner82510133groaner
grocer94212143gro_cer
groggier1134343groggier
groomer10399873groomer
groover11358543groover
grope84821613grop_e_
groped107515053grop_ed
gropers104813853grop_ers
gropes95220403grop_es
groping113313103groping
grosser84313143grosser
grottier9316673grottier
grouper104210093grouper
groupie1045783groupie_
groupies1137523groupies
grouser84513693grouser
grouter84412523grouter
groutier9297173groutier
grower104614933gro_wer
growler11318973growler
growlier1234883growlier
grumpier1334803grumpier
gulfier1137793gulfier
gulper93410213gulp_er
gummier12349473gummier
gunkier12369553gunkier
guppies123310523guppies
gushier113110073gushier
gustier83813863gustier
gutsier8389823gutsier
guttier83911103guttier
gypper14347293g_ypper
happier143312033happier
hempier14319003hempier
hippier143212103hippier
hoarier104211743hoarier
hokier134214033_hokier
holier94921623_holier
homier116416993_homier
hoodie105116143hoodie_
hoodies113419833hoodies
hoofer124014953hoo_fer
hooker134820173hoo_ker
hookies144017443hookies
hoolie93217783hoolie_
hooped125518183hoop_ed
hoopers123616483hoop_ers
hooping133615703hooping
hoopoe11911233hoopoe_
hoopoes121212483hoopoes
hoopster1335543hoopster
hooter94123933hoo_ter
hoover124314433hoo_ver
hoper105829143_hop_er
hopper134218483_hopper
hornier103012463hornier
horsier103013243horsier
hosier94219613_hosier
humpier143110723humpier
jokier17618753_jokier
jollier142911003jollier
joltier14318493joltier
jowlier17327563jowlier
jumpier18317943jumpier
kookie9389843kookie_
koppie14277883koppie_
koppies153210013koppies
lippier112710573lippier
loamier9349163loamier
loftier1037763loftier
loggier93811143loggier
logier75015733_logier
loobies93814103loobies
looie55624243loo_ie_
looies65025833loo_ies
looker104816953loo_ker
loonie64216453loonie_
loonies73919543loonies
looped95217173loop_ed
loopers93914033loop_ers
loopiest103011313loopiest
loopily1236803loopily
looping103615283looping
looser65219943loo_ser
looter64222323loo_ter
loper75129233_lop_er
lopper103717203_lopper
lousier72411623lousier
lowlier10338903lowlier
lumpier113410143lumpier
moldier103110033moldier
moocher143610673moocher
mooner85317833moo_ner
mooter83921093moo_ter
moper94925923_mop_er
mopper126215003_mopper
mossier94413813mossier
mothier121910213mothier
motlier92010583motlier
mousier93712463mousier
myopies14309723myopies
nappier114411173nappier
nippier11319833nippier
nobbier11309163nobbier
noisier759453noisier
noogie73612313noogie_
noogies82814583noogies
nookie103712433nookie_
nookies113414963nookies
nooser65517823noo_ser
nosier63716323_nosier
oakier104011393_oakier
oilier64417233_oilier
oorie53026363_oorie_
orbier839993_orbier
osier53518013__osier
pappier103511593pappier
peopler1138083peopler
peppier10268323peppier
phonier122710633phonier
pier66035293___pier
pipier104913983_pipier
pockier153911603pockier
podgier11338723podgier
pokier124914633_pokier
poofter1237163poofter
pooler83819843poo_ler
pooped113915943poop_ed
pooping123615443pooping
poorer82613993poo_rer
popover1495843popover
popper93615963_popper
poppied11388983poppied
poppies102816193poppies
porkier133712343porkier
pornier93413133pornier
potpie103412433potpie_
potpies113116173potpies
pottier93516493pottier
poutier93215323poutier
poxier153812113_poxier
proper104319953prop_er
prosier93817483prosier
pulpier1148623pulpier
rapier84019993_rapier
raspier93110643raspier
rockier134911883rockier
roilier7311523roilier
romper104213683romp_er
roofer94415283roo_fer
roofie93411173roofie_
roofies103014413roofies
rookie103613263rookie_
rookies113917103rookies
roomer84718633roo_mer
roomie83013873roomie_
roomies93017243roomies
rooser63921883roo_ser
rooster74415173rooster
rooter64926033roo_ter
roper75431913_rop_er
rosier64221263_rosier
rowdier11348593rowdier
sappier113613113sappier
scooper113812033scoop_er
seepier92912013seepier
shopper143312633shopper
showier1339103showier
sloper84615913slop_er
sloppier1255703sloppier
smokier1356703smokier
snooper93511533snoop_er
snootier8278383snootier
snoozier17185193snoozier
snowier1038793snowier
soaper84517873soap_er
soggier93410883soggier
soldier82812153soldier
sonsier7711743sonsier
sooner64220463soo_ner
soother104215043soother
sorrier72313733sorrier
spier75728033__spier
spookier14175493spookier
spoonier10167653spoonier
stonier72013793stonier
stooper93813193stoop_er
stoper84320103stop_er
stopper113012603stopper
swoonier11185133swoonier
swooper12389173swoop_er
tippier113210543tippier
tonier65520713_tonier
tooler63818613too_ler
toonie63617993toonie_
toonies73719883toonies
tooter64420803too_ter
toothier1136423toothier
tootler73511123tootler
toper75231023_top_er
topper103817603_topper
trooper94210363troop_er
typier1137333_typier
vampier14308233vampier
waspier12259053waspier
weepier12319273weepier
whooper15297153whoop_er
whoopie15295933whoopie_
whoopies16267373whoopies
whopper17328503whopper
wimpier14248053wimpier
wispier12249403wispier
wombier1436543wombier
wonkier1437423wonkier
woodie103513613woodie_
woodies113517153woodies
woodsier1245473woodsier
wooer84316693woo__er
woofer124411363woo_fer
wooler93615873woo_ler
woolie93514483woolie_
woolies104117363woolies
woollier1155433woollier
woopsed1344733woopsed
woopses1237883woopses
wordier112511213wordier
wormier12278763wormier
worrier102311683worrier
yolkier14336123yolkier
zappier20458373zappier
zippier20308193zippier

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.423422437.4
2DLD Change Limit1340275075.86022871.5
3Display Results5075070.1862725.8
 (SQL Overall)1786915076.46927622.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.