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

264 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
dufuses1143659(None) 
defuses114814591defuses
defuse105712722defuse_
defused125211092defused
defuser115110502defuser
defusers12487362defusers
defuzes20398302defuzes
diffuses1534832diffuses
disuses84015412disuses
doofuses1244282doofuses
douses74928932d_ouses
druses75517252d_ruses
duffles14308922duffles
dufus94010812dufu__s
dulses73913652du_lses
effuses1335902effuses
fucuses12158352fucuses
fuses85628422__fuses
humuses1237602humuses
infuses102711872infuses
lupuses936272lupuses
lususes736712lususes
mucuses11148512mucuses
refuses104918552refuses
suffuses1435832suffuses
uruses63616502_uruses
abuses85119103_abuses
accuses114112193accuses
amuses85117943_amuses
ankuses1148203ankuses
anuses66218773_anuses
arcuses94814693arcuses
arguses84711743arguses
arouses74921293arouses
auxeses1435623auxeses
bemuses1139293bemuses
blouses94014463blouses
boluses94113833boluses
bonuses94212953bonuses
bouses84931783_bouses
burses84425513bu_rses
buses75936013__buses
busses85023383bu_sses
caucuses1236783caucuses
causes88026473_causes
cayuses12188403cayuses
ceruses93716233ceruses
chouses125117813chouses
clauses93813323clauses
confuses13310363confuses
cruses88127713_cruses
cuisses9319883cuisses
cultuses1037753cultuses
cupules113210263cupules
curses85328273cu_rses
cuscuses1235863cuscuses
cusses84522773cu_sses
cutises94414913cutises
daises74318983d_aises
daubes94913703d_aubes
debases103814133debases
deduces1168793deduces
defaces133213403defaces
defames132812253defames
defenses1237913defenses
defies104624053def_ies
defiles114016843defiles
defines114118683defines
defocuses15134493defocuses
defuel10348933defu_el
defuels11296983defuels
defunds12376753defunds
defuze19487843defuze_
defuzed21447043defuzed
degases93413103degases
degusts936063degusts
delouses9310013delouses
deludes91810643deludes
deluges9169263deluges
demises103719563demises
demoses103815833demoses
denudes91510043denudes
deposes103117213deposes
deputes104911783deputes
deuces94015513d_euces
devises114116763devises
dieses75218693d_ieses
diffuse1444383diffuse_
diffused1643493diffused
diffuser1543153diffuser
diffusers1642783diffusers
dilutes82911973dilutes
dinguses1037643dinguses
discuses113112863discuses
diseuses93112763diseuses
disses75225963d_isses
disuse74012843disuse_
disused93211033disused
diureses936453diureses
divulses1244763divulses
doses65938503d__oses
dosses76126273d_osses
douse66329723d_ouse_
doused84821163d_oused
douser75621633d_ouser
dousers84817273d_ousers
dowses105718303d_owses
dresses83716173dresses
drosses84513823drosses
drowses114610233drowses
drupes94912653d_rupes
druse64817663d_ruse_
duces86327473d__uces
duchess1335553duchess
duchies133312313duchies
duckies143613813duckies
ductules1155543ductules
dudes75424373d__udes
duendes938193duendes
dueness82310123dueness
dues56045503d__u_es
duffel13407753duf_fel
duffels14296453duffels
duffer134711663duf_fer
duffers143410093duffers
duffle13368533duffle_
duffs125216623duf__fs
dukes105023473d__ukes
dulness8307983dulness
dulse65415043du_lse_
dummies123012133dummies
dunces95215753du_nces
dunches133312583dunches
dunes65332173d__unes
dunites8313593dunites
dunness8298983dunness
dupes86425933d__upes
dures65635923d__ures
duress74712063dures_s
duresses939173duresses
durries83817353durries
durums948153duru_ms
dusks105317253d__usks
dusts65923563d__usts
duties74921903du_ties
effuse1234963effuse_
effused1434143effused
excuses1638903excuses
favuses1336183favuses
fetuses10310243fetuses
ficuses12159203ficuses
focuses12159653focuses
fucoses12148303fucoses
fugues104511683fugu_es
fumes105224703__fumes
funguses1254713funguses
furfures1445663furfures
fuse76429993__fuse_
fused94820443__fused
fusee86224583__fusee
fusees95416403__fusees
fusel85218493__fusel
fusels94412453__fusels
fuss76027933__fus_s
fusses94920553fu_sses
futures10310263futures
fuzes175120223__fuzes
genuses83510883genuses
grouses84616543grouses
guesses8169373guesses
guises74216313gu_ises
hocuses121710433hocuses
houses96032283_houses
hummuses1544453hummuses
ictuses938303ictuses
ileuses738673ileuses
incuses93514853incuses
infuse93110573infuse_
infused11329253infused
infuser10298323infuser
infusers11286143infusers
judases1534443judases
jujubes1542083jujubes
kumyses1633143kumyses
lotuses74011253lotuses
louses66230283_louses
lunules738953lunules
minuses93512703minuses
misuses93216023misuses
momuses1159273momuses
mouses85531423_mouses
muffles153910453muffles
muses75134303__muses
musses84624783mu_sses
mutases92012043mutases
mutules9311843mutules
neguses837933neguses
nexuses1436743nexuses
niduses837013niduses
nonuses73313863nonuses
nouses64627163_nouses
nurses63919353nu_rses
onuses65616253_onuses
opuses84012243_opuses
pauses84621473_pauses
perfuses1358663perfuses
peruses94018163peruses
pluses83618073_pluses
prunuses1035123prunuses
pulses83818663pu_lses
purses84826373pu_rses
pursues94111373pursues
puses75532203__puses
pusses84322843pu_sses
quasses16209503quasses
queues153510193queu_es
qurushes2034943qurushes
rebuses94915293rebuses
recuses94619463recuses
refuges115413373refuges
refuse94817513refuse_
refused115114443refused
refuser104912783refuser
refusers11499273refusers
refutes104515733refutes
reuses66025523_reuses
rhuses94911793_rhuses
risuses73210923risuses
rouses65436283_rouses
ruckuses1444913ruckuses
ruffes124112423ruf_fes
ruffles133512273ruffles
rumpuses1235163rumpuses
ruses56136583__ruses
scouses93313243scouses
sinuses73011593sinuses
situses72710493situses
souses64229243_souses
spouses92912813spouses
subfuscs1543753subfuscs
sudses74114503su_dses
suffuse1335443suffuse_
suffused1544023suffused
susses64221053su_sses
sutures7314223sutures
taluses7311213taluses
tonuses73612193tonuses
touses64229673_touses
tubules9310233tubules
tuques15358373tuqu_es
tusses64921243tu_sses
ukases10358063_ukases
unfused11319513unfused
unused72012883_unused
upases84112903_upases
urases63723563_urases
uses44931113___uses
varuses10310623varuses
venuses103111413venuses
viruses1039413viruses
vulguses1243503vulguses
wamuses1237023wamuses
wusses93314893wu_sses
xeruses143010753xeruses

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.436409841.7
2DLD Change Limit1340272646.62620227.4
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.17224915.1
 
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.