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

355 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
fubsier1236776(None) 
fussier103610671fussier
busier85219722bu_sier
fibster12146532fibster
fubsiest13258412fubsiest
fuggier12348962fuggier
fumier11310902fu_mier
funkier14349982funkier
funnier103210172funnier
furrier103513662furrier
furzier19318102furzier
fusser94813772fu_sser
fustier104213932fustier
fuzzier18256522fuzzier
gutsier8389822gutsier
mussier93314362mussier
nubbier11308132nubbier
nutsier7329252nutsier
pursier94012752pursier
pussier93711992pussier
rubier84814742rub_ier
subsider1138242subsider
sudsier868782sudsier
tubbier11237742tubbier
wussier10408082wussier
abuser85413683abus_er
antsier7410773antsier
artsier768943artsier
babier103515573bab_ier
bier65531833__b_ier
bitsier9379073bitsier
bluesier1034943bluesier
bossier93712423bossier
brasier94516753brasier
brier74527403__brier
bubbies103913513bubbies
bubbler103611783bubbler
bubblier1184473bubblier
buffier1568403buffier
buggier113611343buggier
bulgier103911213bulgier
bulkier134111513bulkier
bullier94116433bullier
bumpier13359203bumpier
burblier1255603burblier
burier84324653bu_rier
burlier93514413burlier
burrier93613553burrier
burster9310293burster
busbies113011693busbies
busher114922203bu_sher
bushier123712813bushier
busied95117223bu_sied
busies85525263bu_sies
busker125517833bu_sker
buster84726493bu_ster
bustier93916153bustier
chubbier1733893chubbier
clubbier1434833clubbier
clumsier1234733clumsier
cobbier133410163cobbier
cosier84423753_cosier
crosier94116573crosier
cubbies133312883cubbies
cuber95222533cub__er
cuppier1368323cuppier
curdier103312623curdier
curlier93314183curlier
currier93316703currier
curser84721473curs_er
curvier123110663curvier
cushier123610833cushier
cusser86016093cu_sser
cutesier1045623cutesier
dabster1036703dabster
daubier1037103daub_ier
ditsier83010293ditsier
dossier83711693dossier
dubber113814553dub_ber
duckier143911793duckier
dumpier12409653dumpier
dungier9368583dungier
duskier12409433duskier
duster74919723du_ster
dustier83814133dustier
easier64218463_easier
fabber134814113fab_ber
fabler116115813fab_ler
faddier1237783faddier
faggier12309843faggier
falser93912413fals_er
falsie93513853falsie_
falsies103515013falsies
fancier123412063fancier
farrier103514893farrier
faster94625773f_aster
fattier103513463fattier
faultier1135283faultier
fawnier13296363fawnier
feaster10812983feaster
feistier1136193feistier
fennier10339253fennier
fernier103110823fernier
fester94723513f_ester
fibber134811933fib_ber
fiber104921133fib__er
fibsters13126413fibsters
fierier103511193fierier
filmier1237503filmier
finnier10319953finnier
firrier103410133firrier
fisher124917143f_isher
fishier13359853fishier
fizzier18326713fizzier
flabbier1534093flabbier
flakier143910203flakier
flamier123112143flamier
flasher133914063flasher
flashier1437103flashier
flawier13378733flawier
flaxier17337983flaxier
flesher133610923flesher
fleshier1435603fleshier
flier86023403f__lier
flimsier1344133flimsier
flosser10339693flosser
flossier11326973flossier
flubber14287713flub_ber
fluffier13264333fluffier
flukier14397853flukier
flusher133012273flusher
fluster103913063fluster
flutier103011553flutier
flytier13356503flytier
foamier12339003foamier
foggier12349913foggier
folkier14359043folkier
folksier1533533folksier
footier104115113footier
forkier144311593forkier
foster94322223f_oster
foxier163910033f_oxier
fozier183710663f_ozier
fresher132612643fresher
frier85225843f__rier
frisker14389273frisker
friskier1535193friskier
frostier1148163frostier
frowsier1444893frowsier
fruitier1136593fruitier
frumpier1534173frumpier
fubar1039923fub__ar
fubbed144711243fub_bed
fubbing15409573fubbing
fubs96328793fubs___
fubsy13589273fubs__y
fucker153414423fu_cker
fuddies123211203fuddies
fuehrer1332973fuehrer
fueler94313933fu_eler
fueller10279963fueller
fuhrer1235033fu_hrer
fuller94220383fu_ller
fumbler143610813fumbler
fumer105918233fu__mer
funder104016083fu_nder
funker133915763fu_nker
funner93414103fu_nner
funnies104113603funnies
furbisher1743703furbisher
furies95126373fu_ries
furler93616403fu_rler
furriers11369493furriers
furriery14395683furriery
furriner11267303furriner
further1337003further
fuse76429993fu_s_e_
fused94820443fu_s_ed
fusee86224583fu_s_ee
fusees95416403fu_sees
fusel85218493fu_s_el
fuses85628423fu_s_es
fusil84715323fu_si_l
fusile94313493fu_sile
fusileer1143263fu_sileer
fusilier1135423fusilier
fusils93912343fu_sils
fusing104415953fu_sing
fusion939773fu_sion
fussed104613803fu_ssed
fussers104210813fu_ssers
fusses94920553fu_sses
fussiest112910493fussiest
fussily13267603fussily
fussing113611683fussing
gabbier12379633gabbier
gassier83812573gassier
goosier83512563goosier
gorsier83811073gorsier
grubbier13344753grubbier
guesser8166543guesser
gulfier1137793gulfier
gulpier1046953gulpier
gummier12349473gummier
gunkier12369553gunkier
gusher104115773gu_sher
gushier113110073gushier
gussie72910153gussie_
gussied9267193gussied
gussies82813303gussies
gustier83813863gustier
guttier83911103guttier
hissier103410503hissier
horsier103013243horsier
hosier94219613_hosier
hubbies143211563hubbies
huffier1637493huffier
hulkier14328973hulkier
humpier143110723humpier
hunkier144512143hunkier
hurrier103412943hurrier
husker134212703hu_sker
huskier14369763huskier
hussies103213293hussies
juicier1635463juicier
jumpier18317943jumpier
junkier18339493junkier
juster134617013ju_ster
knubbier1642513knubbier
lobster9288853lobster
lousier72411623lousier
lubber104214623lub_ber
luckier133811533luckier
lumpier113410143lumpier
lunier64617603lu_nier
lusher93818763lu_sher
luster64023673lu_ster
lustier73813503lustier
luthier1038233luthier
massier93615223massier
messier93412923messier
mobster11299213mobster
mossier94413813mossier
mousier93712463mousier
muckier153411483muckier
muddier114110023muddier
muggier11288943muggier
munster93710523munster
murkier133110273murkier
muser76024123mu_s_er
musher113820573mu_sher
mushier123813593mushier
muskier134312733muskier
muster84724523mu_ster
mustier94017963mustier
muzzier17326553muzzier
newsier10147223newsier
nobbier11309163nobbier
noisier759453noisier
nosier63716323_nosier
nubblier1254413nubblier
nurser64314503nurs_er
nuttier73112023nuttier
orbier839993orb_ier
osier53518013__osier
ouster64223733ou_ster
outlier72216143outlier
outsider9269643outsider
prosier93817483prosier
pudgier11377723pudgier
puffier1547973puffier
puggier11309383puggier
pulpier1148623pulpier
pulser84215193puls_er
punier84519223pu_nier
punkier133512793punkier
punnier93511263punnier
punster92911103punster
purser85020473purs_er
pursuer9338893pursuer
purtier93214093purtier
pusher114318283pu_sher
pushier123611093pushier
pussies93615693pussies
puttier93314503puttier
quakier20239203quakier
quasher19198623quasher
queasier1734473queasier
querier16310013querier
quester161410023quester
ribbier1137593ribbier
ribier84414233rib_ier
rosier64221263_rosier
rubber104715793rub_ber
rubbies114114113rubbies
rubblier1244913rubblier
rubied94312413rub_ied
rubies84420343rub_ies
ruddier9338523ruddier
rulier65016353ru_lier
rummier11309563rummier
runnier74010113runnier
runtier73512853runtier
rusher94019653ru_sher
rushier103411973rushier
rustier74416363rustier
ruttier73412283ruttier
sassier73413233sassier
sissier73711363sissier
snubbier1244993snubbier
sonsier7711743sonsier
stubbier1235353stubbier
subduer10107033subduer
suber74924503sub__er
sublimer1237613sublimer
subsea82610193subs_ea
subsere9311443subs_ere
subset83122583subs_et
subside10410453subside
subsided1257663subsided
subsiders1246053subsiders
subsides11410823subsides
subsidy1345973subsidy
subsist9311573subsist
subsister1145983subsister
subsite9412873subsite
subsites10312783subsites
subsoiler1145323subsoiler
subtiler10208573subtiler
subtler92910843subtler
suckier133613973suckier
sudser73511283suds_er
sulkier113811963sulkier
sunnier73412153sunnier
surfier102613543surfier
surlier72915443surlier
tarsier74119253tarsier
tipsier9268893tipsier
tubber104313203tub_ber
tuber75420683tub__er
tuftier1096603tuftier
turfier10249793turfier
tusker104212193tu_sker
tusser64615833tu_sser
uglier748953_uglier
ulster63712103_ulster
user45023003_u_s_er
usher84517763_u_sher
vuggier12296813vuggier
webbier1445423webbier
webster1236093webster
wussies103411083wussies
yuckier16358533yuckier
yukkier13263893yukkier
yummier14306843yummier

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.440406115.9
2DLD Change Limit1340273556.67020094.0
3Display Results3553550.1262817.5
 (SQL Overall)1786913557.23624694.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.