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
redd6632317(None) 
read55942531read
readd74617131readd
red46755801re_d
redds74617831redds
rede55037661rede
reded74829111reded
redid74922391redid
redo56029361redo
reds56042861reds
reed55549621reed
rend56136571rend
rudd65917471rudd
add510132362_add
bead75937922bead
bed67950622be_d
beds75937782beds
bedu75923692bedu
bend76435262bend
bread85523112bread
bred75130972bre_d
brede85520502brede
breed85526692breed
cede74928762cede
ceded96118552ceded
cedi74919272cedi
cred76530882cre_d
credo84815562credo
creds85418772creds
creed85727392creed
dead65434242dead
deed65340902deed
dread74419022dread
dreed75222842dreed
ed38645182_e_d
eddo63411802_eddo
eddy93912092_eddy
edh76921562_edh
eds46638922_eds
eld46733792_eld
end46834352_end
fed76548352fe_d
feds85234312feds
feed84538902feed
fend84832972fend
feod815523002feod
feud86523022feud
freed95223542freed
fremd115010322fremd
ged57044532ge_d
geds66730812geds
geed65435502geed
geld65828432geld
greed75125692greed
head87137172head
heed86437602heed
held85330402held
herd84933062herd
ired55131872ire_d
jeed125428502jeed
lead56038852lead
led46254552le_d
lend56233672lend
leud57223422leud
lewd85716592lewd
mead75531602mead
med66146742me_d
meds75735362meds
meed74934702meed
meld75830472meld
mend75334022mend
neddy10479872neddy
need54934152need
nerd56624942nerd
odd57725452_odd
oread64619602oread
ped66751522pe_d
peds75835242peds
peed76239182peed
pend75934532pend
preed85128112preed
rad47662002r_ad
rads56046602rads
raid55243072raid
rand55839562rand
re26153742re__
readds84111642readds
reads64835272reads
ready94821502ready
real45750292real
ream65841612ream
reap65934742reap
rear45644552rear
reb55844962re_b
rebid85121352rebid
rebs65733562rebs
rec55645462re_c
reck106130562reck
recs65734182recs
redan66125012redan
redbud10135802redbud
redded94019542redded
redden83613612redden
redder83918132redder
reddle83815912reddle
redes65139122redes
redia65524482redia
redip87816962redip
redly94217192redly
redon65424882redon
redos65126762redos
redox134714232redox
redry94314362redry
redub84212412redub
redux133811102redux
redye94413462redye
redyed114611232redyed
ree37974072re_e
reeded84022562reeded
reeds65430902reeds
reedy910020282reedy
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
ref66053292re_f
refed93921922refed
refs75732242refs
reft75141272reft
reg46146492re_g
regs55436572regs
rei35647252re_i
reif76937642reif
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
rid46754622r_id
ride55945122ride
rids56539542rids
rind56535602rind
road56332112road
rod47953892r_od
rode55844302rode
rods56442062rods
rood56733002rood
rudds74811702rudds
ruddy104511752ruddy
rude55632782rude
rued55729792rued
rynd86414102rynd
seed55549482seed
send55237292send
sudd64719772sudd
ted46446562te_d
teddy10489492teddy
teds54932572teds
teed55439262teed
tend56433772tend
tread64821702tread
treed65626732treed
trend64817452trend
uredo65112992uredo
veld85323202veld
vend86626422vend
wed75843622we_d
weds86628932weds
weed85637512weed
weld84727732weld
wend85330452wend
yeld811423872yeld
zed135431172ze_d
zeds145821802zeds

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.0632836365.1
2DLD Change Limit298721930.98330388.6
3Display Results1931930.0464195.7
 (SQL Overall)1786911931.092163636.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.