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

145 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
doux12581798(None) 
doum76226671doum
dour56330431dour
roux117419361roux
bout66353292bout
box1210142342bo_x
brux136315272brux
coax136922982coax
coup86729792coup
cox1210346782co_x
crux135415002crux
daub77423442daub
daut56443562daut
dex116936882d_ex
do310155252do__
doat56947672doat
doby106022162doby
doc66841512do_c
dock116228742dock
docs75631152docs
dodo66024912dodo
doe47361952do_e
doer57734702doer
does56554472does
doff116225782doff
dog57449752do_g
doge66233802doge
dogs66440152dogs
dogy96126492dogy
doit56347852doit
dojo126016142dojo
dol47150652do_l
dole56550002dole
doll56632492doll
dols56943052dols
dolt56649422dolt
dom69752442do_m
dome77240732dome
doms76239572doms
don46757652do_n
dona55529632dona
done55747912done
dong66031652dong
dons56048702dons
donut6324512donut
doom76430072doom
door56928512door
dopa77220902dopa
dope76038892dope
dopy106224152dopy
dor47253922do_r
dore56353302dore
dork96531462dork
dorm76834632dorm
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dory85836232dory
dos48062312do_s
dose56442432dose
doss56235042doss
dost57248352dost
dot47573182do_t
dote55442882dote
doth86225712doth
dots55647662dots
doty86128222doty
doubt8720092doubt
douce85518422douce
dough105217382dough
doula65717772doula
douma85817702douma
doums85417642doums
doura66518662doura
douse66329722douse
dove85131562dove
dow76749972do_w
down86427492down
dows85941052dows
doxy156419952doxy
doze145829082doze
dozy175920322dozy
drouk1039432drouk
drub75920132drub
drug65718132drug
drum76521592drum
dub66642202d_ub
dud56737592d_ud
due45249862d_ue
dug58138692d_ug
duh77930382d_uh
dui46433382d_ui
dun46545582d_un
duo48536142d_uo
duos56728132duos
dup67637882d_up
eaux116618422eaux
faux146519072faux
flux145617742flux
fou66743782fou_
foul77027582foul
four76226862four
fox136737862fo_x
gout56646002gout
gox117137182go_x
hoax147718292hoax
hour75827312hour
jeux184311272jeux
jouk156015992jouk
loud55228042loud
loup66028432loup
lour45430682lour
lout45952142lout
lox108240962lo_x
lux106528772_lux
moue65835572moue
noun45724182noun
nous46136982nous
odour64710492odour
oud47439072_oud
our36042892_our
out38072152_out
ox98242382_o_x
pouf95732642pouf
pour611527472pour
pout65752552pout
pox126140692po_x
roue45941742roue
roup66627692roup
rout46153282rout
sou37853692sou_
souk86127172souk
soul46435712soul
soup66232912soup
sour45935892sour
sous46947212sous
sox106444192so_x
tour45530382tour
tout46753822tout
tux105426572_tux
vox136628152vo_x
you66641822you_
your78623432your
yous76230652yous
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.266671770.7
2DLD Change Limit298721450.84335435.3
3Display Results1451450.0463152.2
 (SQL Overall)1786911451.155154710.8
 
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.