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

193 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
redd6632318(None) 
read55942531read
readd74617131readd
red46755811re_d
redds74617831redds
rede55037681rede
reded74829121reded
redid74922391redid
redo56029371redo
reds56042871reds
reed55549621reed
rend56136571rend
rudd65917481rudd
add510132372_add
bead75937922bead
bed67950632be_d
beds75937792beds
bedu75923702bedu
bend76435262bend
bread85523112bread
bred75130972bre_d
brede85520502brede
breed85526692breed
cede74928782cede
ceded96118562ceded
cedi74919282cedi
cred76530882cre_d
credo84815572credo
creds85418772creds
creed85727392creed
dead65434242dead
deed65340902deed
dread74419022dread
dreed75222842dreed
ed38645192_e_d
eddo63411812_eddo
eddy93912102_eddy
edh76921572_edh
eds46638932_eds
eld46733802_eld
end46834362_end
fed76548362fe_d
feds85234322feds
feed84538902feed
fend84832972fend
feod815523002feod
feud86523022feud
freed95223542freed
fremd115010322fremd
ged57044542ge_d
geds66730822geds
geed65435502geed
geld65828432geld
greed75125692greed
head87137172head
heed86437602heed
held85330402held
herd84933062herd
ired55131872ire_d
jeed125428502jeed
lead56038852lead
led46254562le_d
lend56233672lend
leud57223422leud
lewd85716592lewd
mead75531602mead
med66146752me_d
meds75735372meds
meed74934702meed
meld75830472meld
mend75334032mend
neddy10479872neddy
need54934152need
nerd56624942nerd
odd57725462_odd
oread64619602oread
ped66751532pe_d
peds75835252peds
peed76239182peed
pend75934532pend
preed85128122preed
rad47662012r_ad
rads56046612rads
raid55243082raid
rand55839572rand
re26153742re__
readds84111642readds
reads64835272reads
ready94821502ready
real45750292real
ream65841612ream
reap65934742reap
rear45644552rear
reb55844962re_b
rebid85121362rebid
rebs65733562rebs
rec55645462re_c
reck106130562reck
recs65734182recs
redan66125012redan
redbud10135802redbud
redded94019552redded
redden83613622redden
redder83918142redder
reddle83815912reddle
redes65139132redes
redia65524482redia
redip87816962redip
redly94217202redly
redon65424882redon
redos65126762redos
redox134714232redox
redry94314362redry
redub84212412redub
redux133811102redux
redye94413472redye
redyed114611242redyed
ree37974072re_e
reeded84022562reeded
reeds65430902reeds
reedy910020292reedy
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
ref66053292re_f
refed93921922refed
refs75732242refs
reft75141272reft
reg46146492re_g
regs55436572regs
rei35647252re_i
reif76937652reif
rein46040892rein
reis45343232reis
rely75428952rely
rem56150042re_m
rems66237722rems
rended84524102rended
rends65129952rends
rent46661242rent
rep55847802re_p
repo66027542repo
repp85418742repp
reps65937952reps
res35565042re_s
resh76523452resh
resid64124092resid
resod64720052resod
rest46459842rest
ret35982832re_t
rete44944132rete
rets45352562rets
rev65336622re_v
revs75027052revs
rewed95425452rewed
rex105740992re_x
rid46754642r_id
ride55945142ride
rids56539562rids
rind56535612rind
road56332112road
rod47953902r_od
rode55844312rode
rods56442072rods
rood56733002rood
rudds74811702rudds
ruddy104511752ruddy
rude55632792rude
rued55729792rued
rynd86414102rynd
seed55549482seed
send55237292send
sudd64719782sudd
ted46446572te_d
teddy10489492teddy
teds54932582teds
teed55439262teed
tend56433772tend
tread64821702tread
treed65626732treed
trend64817452trend
uredo65112992uredo
veld85323202veld
vend86626422vend
wed75843632we_d
weds86628942weds
weed85637512weed
weld84727732weld
wend85330452wend
yeld811423872yeld
zed135431182ze_d
zeds145821812zeds

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 Limit298721930.97030795.9
3Display Results1931930.0464195.7
 (SQL Overall)1786911931.296137878.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.