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

155 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
yaud8702008(None) 
baud74928421baud
gaud67025431gaud
laud56527721laud
maud75325401maud
yald86920611yald
yard85633251yard
yauds95013221yauds
yauld95511181yauld
yaup96618481yaup
ad311975042_a_d
add510132372_add
aid49269092_aid
and47244182_and
auk76234142_auk
auld54125362_auld
bad67763162ba_d
bald76432902bald
band76740922band
bard75648862bard
bauds85821042bauds
bawd105520842bawd
bud67041282_bud
cad67456372ca_d
caid77837542caid
card710245872card
caul65630002caul
cauld85318442cauld
crud75219612crud
cud67937462_cud
dad58456172da_d
daub77423442daub
daut56443562daut
duad66521412duad
dud56737602_dud
dyad96415452dya_d
eau37450942eau_
eaux116618422eaux
fad77452422fa_d
fard85639062fard
fauld95214492fauld
faun76226622faun
faux146519072faux
feud86523022feud
fraud939862fraud
fud76335162_fud
gad57556662ga_d
gaed66031512gaed
gauds75717722gauds
gaudy106611462gaudy
gaum75726422gaum
gaun56427712gaun
gaur56723352gaur
had77658772ha_d
haed86338582haed
hand86833712hand
hard85443502hard
haul75530452haul
haut75949732haut
jauk155816092jauk
jaup135316422jaup
lad48165712la_d
laid56439152laid
land56337312land
lard56742002lard
lauds65618482lauds
leud57223422leud
loud55228042loud
lyard95113212lyard
mad68958722ma_d
maid75537672maid
mauds85519272mauds
maul64830722maul
maun65727212maun
maund85515452maund
maut65448452maut
mud67336872_mud
nard56634452nard
oud47439082_oud
pad68057332pa_d
paid75737492paid
pard76441322pard
pud65836662_pud
qaid146023852qaid
quad144618702quad
rad47662012ra_d
raid55243082raid
rand55839572rand
sad47459212sa_d
said55742122said
sand55338472sand
sard55344242sard
sau36356572sau_
saul45836522saul
scud76221282scud
spud75818492spud
stud56220092stud
tad47959832ta_d
tau36856902tau_
taus46342732taus
taut47048962taut
thud85613912thud
vau66840872vau_
vaus75928922vaus
wad77053902wa_d
wand85833882wand
ward86542252ward
wauk115220592wauk
waul76927312waul
waur76819902waur
wud76227162_wud
ya510251502ya__
yack135425972yack
yaff135324262yaff
yag76947732ya_g
yagi86922242yagi
yags86632292yags
yah99046352ya_h
yaird96111912yaird
yak107038562ya_k
yaks116025202yaks
yam87448992ya_m
yams95330732yams
yamun10419272yamun
yang85626082yang
yank115423672yank
yap85949822ya_p
yaps95933522yaps
yar67253832ya_r
yards95324612yards
yare75636942yare
yarn75230042yarn
yauped12408332yauped
yaups105910742yaups
yaw97145152ya_w
yawed126022452yawed
yawl104918972yawl
yawn106219092yawn
yawp125215582yawp
yaws105531212yaws
yay96948712ya_y
yays105728912yays
yeld811423872yeld
yeuk116015472yeuk
yid76640842y_id
yird87018992yird
yod77545512y_od
yond86122312yond
you66641822you_
your78623432your
yous76230652yous
yuan76120012yuan
yuk106725602y_uk
yum86132822y_um
yup86031702y_up

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.280638182.1
2DLD Change Limit298721550.89333451.3
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.219146588.2
 
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.