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

178 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
redo5602936(None) 
credo84815561credo
red46755801red_
redd66323171redd
rede55037661rede
redon65424881redon
redos65126761redos
redox134714231redox
reds56042861reds
repo66027541repo
uredo65112991uredo
ado49146872_ado
aero45435342aero
bed67950622bed_
beds75937782beds
bedu75923692bedu
bred75130972bred_
brede85520502brede
cede74928762cede
cedi74919272cedi
cero66329452cero
cred76530882cred_
credos94612842credos
creds85418772creds
dado67126332dado
deco76125972deco
demo77427552demo
dido66528192dido
do310155252__do
dodo66024912dodo
ed38645182_ed_
eddo63411802eddo
edh76921562_edh
eds46638922_eds
ego46726052_ego
ergo56420152ergo
fado87226462fado
fed76548352fed_
feds85234312feds
feod815523002feod
fido87726392fido
foredo10510822foredo
ged57044532ged_
geds66730812geds
grego7310522grego
helo75332852helo
hero74635782hero
ired55131872ired_
judo125315302judo
kendo105113222kendo
keno87926432keno
keto86223452keto
kudo96115102kudo
led46254552led_
leno47331392leno
levo76820062levo
lido56028152lido
med66146742med_
meds75735362meds
memo85924792memo
meno66031352meno
ordo54622352ordo
ped66751522ped_
pedro8313152pedro
peds75835242peds
pepo87622152pepo
peso66925822peso
rad47662002rad_
radio64922492radio
radon64620502radon
rads56046602rads
rato45436972rato
re26153742re__
read55942532read
readd74617132readd
reads64835272reads
ready94821502ready
real45750292real
ream65841612ream
reap65934742reap
rear45644552rear
reb55844962re_b
rebop9313282rebop
rebs65733562rebs
rec55645462re_c
reck106130562reck
recon75624242recon
recs65734182recs
recto74520802recto
redan66125012redan
redds74617832redds
reded74829112reded
redes65139122redes
redia65524482redia
redid74922392redid
redip87816962redip
redly94217192redly
redock134311542redock
redoes74623752redoes
redone74820052redone
redons75222182redons
redout71820252redout
redowa1038452redowa
redry94314362redry
redtop937972redtop
redub84212412redub
redux133811102redux
redye94413462redye
ree37974072re_e
reed55549622reed
reeds65430902reeds
reedy910020282reedy
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
ref66053292re_f
refs75732242refs
reft75141272reft
reg46146492re_g
regs55436572regs
rei35647252re_i
reif76937642reif
rein46040892rein
reis45343232reis
rely75428952rely
rem56150042re_m
rems66237722rems
rend56136572rend
rends65129952rends
rent46661242rent
rep55847802re_p
repos74725792repos
repot75132622repot
repp85418742repp
repro75315912repro
reps65937952reps
res35565042re_s
resh76523452resh
resod64720052resod
resow88217242resow
rest46459842rest
ret35982832re_t
rete44944132rete
retro55020952retro
rets45352562rets
rev65336622re_v
revs75027052revs
rewon86920572rewon
rex105740992re_x
rho65924832r_ho
rid46754622rid_
ride55945122ride
rids56539542rids
rod47953892rod_
rode55844302rode
rodeo65921092rodeo
rods56442062rods
rondo65218372rondo
rood56733002rood
roto45935052roto
rudd65917472rudd
rude55632782rude
rued55729792rued_
sego56525182sego
ted46446562ted_
teds54932572teds
teredo7310782teredo
udo49027302_udo
undo55620152undo
updo76712882updo
uredos73910622uredos
veto76622992veto
wed75843622wed_
weds86628932weds
zed135431172zed_
zeds145821802zeds
zero134822462zero

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 Limit298721780.89033564.0
3Display Results1781780.0463869.6
 (SQL Overall)1786911780.999178869.9
 
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.