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 “dumas” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

169 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
dumas8542043(None) 
doumas95314811doumas
duma75524451duma_
dumbs105915751dumbs
dumps105220101dumps
duras65727731duras
lumas75622911lumas
pumas95121561pumas
agmas85919872agmas
almas76629772almas
amas67746292_amas
atmas75721012atmas
auras55932562auras
bemas96424282bemas
bimas95521742bimas
bumfs125414052bumfs
bumps115921142bumps
bums85934592bum_s
bunas75126572bunas
buras74736302buras
camas96333522camas
comas95833002comas
cymas126417882cymas
dadas75819862dadas
daman84821162daman
damans94715982damans
damar84117732damar
damars93814992damars
damask1335842damask
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372dam_s
degas75119162degas
demast9517062demast
demes86032692demes
demos86022992demos
dermas94116812dermas
devas96218882devas
dimes85833042dimes
dims75435022dim_s
ditas65923672ditas
divas95418582divas
dogmas105011242dogmas
dolmas95213042dolmas
domal85619202domal
domes85735562domes
doms76239572dom_s
donas65926472donas
dopas85019062dopas
doulas75114992doulas
douma85817702douma_
doums85417642doum_s
douras75016722douras
dramas95814652dramas
drams86025832drams
drums85415872drum_s
duad66521412du_ad
duads76515342duads
dual55928172du_al
duals65620082duals
dubs78432192du_bs
ducal84816422ducal
ducat86225902ducat
ducats95011762ducats
duces86327472duces
ducks124823212ducks
ducts85319892ducts
dudes75424372dudes
duds65530142du_ds
duels65619232duels
dues56045502du_es
duets65323882duets
duffs125216622duffs
dufus94010812dufus
dugs614832282du_gs
duits65021882duits
dukes105023472dukes
dulias71212742dulias
dulls64523742dulls
dumb97124102dum_b
dumbo105614062dumbo
dumbos114111082dumbos
dumka12438832dumka
dumky154511342dumky
dummy134712782dummy
dump95927092dum_p
dumpy135414752dumpy
dunam8313732dunam
dunams937832dunams
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432du_ns
dunts65828412dunts
duomos936822duomos
duos56728132du_os
dupes86425932dupes
dups75929512du_ps
dura55232112dura_
dural64923892dural
dures65635922dures
durmast1037622durmast
durns64819872durns
duros65422692duros
durras74713372durras
durrs65519992durrs
dusks105317252dusks
dusts65923562dusts
edemas9310502edemas
fumes105224702fumes
gamas85431362gamas
gummas114810512gummas
gums75030942gum_s
hulas84920882hulas
human102716032human
humans112312432humans
humps126322802humps
hums96831422hum_s
humus106215072humus
jubas144614222jubas
judas134911882judas
jumps165116492jumps
kumys1435932kumys
lamas75532792lamas
limas75627632limas
loumas84812332loumas
luma65527522luma_
lumps95624982lumps
lums65734242lum_s
lunas55025012lunas
mamas95930772mamas
mas58175822__mas
mumms85513152mumms
mumps115619102mumps
mums85732772mum_s
mumus95517282mumus
muras75329582muras
nemas75321572nemas
nomas74726412nomas
numbs94913092numbs
pimas94725102pimas
pujas145513322pujas
puma85424122puma_
pumps115520602pumps
punas74826752punas
pupas95219282pupas
rumbas102512012rumbas
rumps95922292rumps
rums64833472rum_s
simas75727552simas
somas76030372somas
subas74724072subas
sumac99514882sumac
sumacs105512102sumacs
summas104313162summas
sumos75720092sumos
sumps95023432sumps
sums65837582sum_s
suras55336332suras
tubas75119582tubas
tufas85314382tufas
tumps95420792tumps
tunas54224122tunas
umps85721942_umps
upas68322382_upas
utas45924952_utas
yucas106013912yucas
yugas95012062yugas

Search took 3 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 Filter178691538000.390458182.1
2DLD Change Limit538001691.84329191.5
3Display Results1691690.0463673.9
 (SQL Overall)1786911692.27978407.6
 
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.