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

206 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
doum7622667(None) 
dom69752441do_m
doom76430071doom
dorm76834631dorm
douma85817701douma
doums85417641doums
dour56330431dour
doux125817981doux
drum76521591drum
alum65227612alum
arum66129032arum
boom87435672boom
bout66353292bout
bum75342692_bum
chum116318002chum
corm85735372corm
coup86729792coup
cum76440162_cum
dam67457042d_am
datum8310632datum
daub77423442daub
daut56443562daut
deem75432892deem
degum94711902degum
derm76031892derm
dim68146492d_im
do310155252do__
doat56947672doat
doby106022162doby
doc66841512do_c
dock116228742dock
docs75631152docs
dodo66024912dodo
doe47361952do_e
doer57734702doer
does56554472does
doff116225782doff
dog57449752do_g
doge66233802doge
dogma96112462dogma
dogs66440152dogs
dogy96126492dogy
doit56347852doit
dojo126016142dojo
dol47150652do_l
dole56550002dole
doll56632492doll
dolma86214172dolma
dols56943052dols
dolt56649422dolt
dome77240732dome
doms76239572doms
don46757652do_n
dona55529632dona
done55747912done
dong66031652dong
dons56048702dons
donut6324512donut
dooms85321342dooms
doomy116018262doomy
door56928512door
dopa77220902dopa
dope76038892dope
dopy106224152dopy
dor47253922do_r
dore56353302dore
dork96531462dork
dorms85723842dorms
dormy115817472dormy
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dorsum947622dorsum
dory85836232dory
dos48062312do_s
dose56442432dose
doss56235042doss
dost57248352dost
dot47573182do_t
dote55442882dote
doth86225712doth
dots55647662dots
doty86128222doty
doubt8720092doubt
douce85518422douce
dough105217382dough
doula65717772doula
doumas95314812doumas
doura66518662doura
douse66329722douse
dove85131562dove
dow76749972do_w
down86427492down
dows85941052dows
doxy156419952doxy
doze145829082doze
dozy175920322dozy
dram75832002dram
drouk1039432drouk
drub75920132drub
drug65718132drug
drums85415872drums
dub66642202d_ub
dud56737592d_ud
due45249862d_ue
dug58138692d_ug
duh77930382d_uh
dui46433382d_ui
duma75524452d_uma
dumb97124102d_umb
dump95927092d_ump
dun46545582d_un
duo48536142d_uo
duomi8310132duomi
duomo839752duomo
duos56728132duos
dup67637882d_up
durum8513202durum
foam97127172foam
form95836872form
forum108318762forum
fou66743782fou_
foul77027582foul
four76226862four
gaum75726422gaum
geum75424552geum
glum75825102glum
gorm75529392gorm
gout56646002gout
grum75625082grum
gum67439532_gum
hokum1436772hokum
holm95628112holm
hour75827312hour
hum85542932_hum
jorum145513742jorum
jouk156015992jouk
khoum1476642khoum
loam65630482loam
locum94812172locum
loom67035052loom
loud55228042loud
louma76213632louma
loup66028432loup
lour45430682lour
lout45952142lout
lum55542932_lum
mom78853162mo_m
moue65835572moue
mum76643612_mum
neum66723082neum
nom510450642no_m
norm66429812norm
notum7611692notum
noun45724182noun
nous46136982nous
odeum84610542odeum
odium83413032odium
odour64710492odour
ohm86523012_ohm
om48553002_o_m
oud47439072_oud
our36042892_our
out38072152_out
ovum92310172ovum
plum85122102plum
poem86225772poem
pom78249912po_m
pouf95732642pouf
pour611527472pour
pout65752552pout
roam67132412roam
rom59855632ro_m
room66235082room
roue45941742roue
roup66627692roup
rout46153282rout
roux117419362roux
rum56644642_rum
scum85924522scum
slum65430512slum
solum74717612solum
som59153812so_m
sou37853692sou_
souk86127172souk
soul46435712soul
soup66232912soup
sour45935892sour
sous46947212sous
stum65526022stum
sum56346012_sum
swum96416822swum
tom514358052to_m
toom66532932toom
tour45530382tour
tout46753822tout
um47338832__um
vum85428652_vum
worm96129482worm
yom88043442yo_m
you66641822you_
your78623432your
yous76230652yous
yum86132822_yum
zoom156722102zoom
zouk174413542zouk

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298722060.86034734.9
3Display Results2062060.0464478.3
 (SQL Overall)1786912060.982181966.4
 
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.