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

184 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
doums8541764(None) 
doms76239571do_ms
dooms85321341dooms
dorms85723841dorms
doum76226671doum_
douma85817701douma
doumas95314811doumas
drums85415871drums
alums75720602alums
arums75517832arums
booms95427122booms
bouts75131312bouts
bums85934592_bums
chums125015832chums
corms95626222corms
coups95522472coups
dams77444372d_ams
datums936352datums
daubs85014562daubs
dauts67822242dauts
deems85421772deems
degums10438622degums
derms85022892derms
dims75435032d_ims
doats65224882doats
docks126022312docks
docs75631152do_cs
dodos75819392dodos
doers65225712doers
does56554472do_es
doffs125614332doffs
doges75630162doges
dogma96112462dogma
dogmas105011242dogmas
dogs66440152do_gs
doits66223672doits
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dolma86214172dolma
dolmas95213042dolmas
dols56943052do_ls
dolts65626312dolts
dom69752442do_m_
dome77240732do_me
domes85735562domes
donas65926472donas
dongs76525812dongs
dons56048702do_ns
donuts7410582donuts
doom76430072doom_
doomy116018262doomy
doors65022132doors
dopas85019062dopas
dopes84935042dopes
dorks105724442dorks
dorm76834632dorm_
dormy115817472dormy
dorps85419222dorps
dorrs65520592dorrs
dors56747602do_rs
dos48062312do__s
doses65938502doses
doss56235042do_ss
dotes65836692dotes
dots55647662do_ts
doubt8720092doubt
doubts968732doubts
douce85518422douce
dough105217382dough
doughs115912932doughs
doula65717772doula
doulas75114992doulas
dour56330432dou_r
doura66518662doura
douras75016722douras
douse66329722douse
douses74928932douses
doux125817982dou_x
doves94728152doves
downs94918572downs
dows85941052do_ws
dozes155226302dozes
drams86025832drams
drouks1137122drouks
drubs85913832drubs
drugs75214652drugs
drum76521592drum_
dubs78432192d_ubs
duds65530152d_uds
dues56045502d_ues
dugs614832282d_ugs
duma75524452d_uma
dumas85420432d_umas
dumb97124102d_umb
dumbs105915752d_umbs
dump95927092d_ump
dumps105220102d_umps
duns55140432d_uns
duomi8310132duomi
duomo839752duomo
duomos936822duomos
duos56728132d_uos
dups75929512d_ups
durums948152durums
foams105017952foams
forms105327052forms
forums114611842forums
fouls87221432fouls
fours85521492fours
gaums86217072gaums
geums85414112geums
glums84621422glums
gorms85619592gorms
gouts64826172gouts
gums75030942_gums
hokums1533922hokums
holms105117802holms
hours85422392hours
hums96831422_hums
jorums15408092jorums
jouks165612342jouks
khoums1594012khoums
koumis1237622koumis
koumys1543302koumys
loams75619862loams
locums10478302locums
looms75124642looms
louis57322322louis
louma76213632louma
loumas84812332loumas
loups75319622loups
lours55125292lours
louts56330272louts
lums65734242_lums
moms86539482mo_ms
momus96116112momus
moues75732842moues
mums85732772_mums
neums75414252neums
noms65636402no_ms
norms76019312norms
nouns56717312nouns
nous46136982nou_s
odeums9367312odeums
odiums9337942odiums
odours7418252odours
ohms95514032_ohms
oms56337512_o_ms
ouds56430112_ouds
ours47237562_ours
outs45746962_outs
plums94619952plums
poems95715552poems
poms87037742po_ms
poufs105616062poufs
pours74623182pours
pouts75530322pouts
roams74919612roams
roms67038962ro_ms
rooms75324682rooms
roues56039352roues
roups75118902roups
routs57133412routs
rums64833472_rums
scums95017422scums
slums74623432slums
solums85211332solums
soms66239372so_ms
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212sou_s
stums75320082stums
sums65837582_sums
toms68343492to_ms
tours55325892tours
touts54830392touts
worms105320762worms
yours85217882yours
yous76230652you_s
zooms164415522zooms
zouks184410502zouks

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.296603685.8
2DLD Change Limit538001841.68631909.8
3Display Results1841840.0464000.0
 (SQL Overall)1786911842.02888111.9
 
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.