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

157 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
redos6512676(None) 
credos94612851credos
redds74617831redds
redes65139131redes
redo56029361redo_
redoes74623771redoes
redon65424881redon
redons75222181redons
redox134714231redox
reds56042861red_s
repos74725791repos
uredos73910621uredos
ados57633512_ados
aedes64625152aedes
beds75937782bed_s
bredes94818472bredes
cedes84927332cedes
cedis84317082cedis
ceros74726072ceros
credo84815572credo_
creds85418772cred_s
dados75522432dados
decos85522122decos
demos86022992demos
didos76820812didos
dodos75819392dodos
dos48062312__dos
edhs86212102_edhs
eds46638922_ed_s
egos55821652_egos
eidos65817752eidos
epos66723732_epos
eros45238452_eros
fados95620732fados
feds85234312fed_s
feods99516852feods
fidos95819052fidos
geds66730812ged_s
gregos847532gregos
helos84928062helos
heros84930862heros
judos134711732judos
kendos114510662kendos
kenos95220622kenos
kudos105011252kudos
lenos56024862lenos
lidos65219882lidos
meds75735362med_s
memos95719112memos
ordos65216202ordos
pedes85327292pedes
pedros9312182pedros
peds75835242ped_s
pepos96620082pepos
pesos77221622pesos
radios74018672radios
radon64620502radon
radons74118532radons
rads56046602rad_s
ratos55528762ratos
readds84111642readds
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
rebop9313282rebop
rebops10311432rebops
rebs65733562re_bs
rebus75721112rebus
recks115625132recks
recon75624242recon
recons84922992recons
recs65734182re_cs
rectos85718782rectos
red46755802red__
redan66125012redan
redans75421022redans
redd66323172red_d
rede55037672red_e
reded74829122reded
redia65524482redia
redias74523602redias
redid74922392redid
redip87816962redip
redips93713842redips
redly94217202redly
redock134311542redock
redocks14409932redocks
redone74820052redone
redout71820252redout
redouts81411662redouts
redowa1038452redowa
redowas1138392redowas
redoxes15310882redoxes
redry94314362redry
redtop937972redtop
redtops1037372redtops
redub84212412redub
redubs9358382redubs
redux133811102redux
redye94413472redye
redyes104214092redyes
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192re_es
refs75732242re_fs
reges65628792reges
regs55436572re_gs
reifs84819092reifs
reins56234562reins
reis45343232re_is
rems66237722re_ms
rends65129952rends
rents55935182rents
repo66027542repo_
repose84121412repose
repot75132622repot
repots85621002repots
repps95114342repps
repros84216002repros
reps65937952re_ps
reredos838632reredos
rerose63320842rerose
res35565042re__s
resod64720052resod
resods74116302resods
resow88217242resow
resows93915352resows
rests54935872rests
retros63820192retros
rets45352562re_ts
revs75027052re_vs
rewon86920582rewon
rexes124526952rexes
rhos76319062r_hos
rides66140812rides
rids56539552rid_s
rodeos75314502rodeos
rodes614039082rodes
rods56442062rod_s
rondos74616732rondos
roods65125282roods
rotos56027882rotos
rudds74811702rudds
segos64919482segos
teds54932572ted_s
telos55424522telos
teredos839182teredos
udos56619902_udos
updos8389512updos
uredo65112992uredo_
weds86628932wed_s
zeds145821802zed_s
zeros144918112zeros

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 Filter178691538000.346516448.0
2DLD Change Limit538001571.51335558.5
3Display Results1571570.0463413.0
 (SQL Overall)1786911571.90593801.0
 
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.