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

103 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
redon6542488(None) 
radon64620501radon
recon75624241recon
redan66125011redan
redo56029361redo_
redone74820051redone
redons75222181redons
redos65126761redos
redox134714231redox
rewon86920571rewon
aeon45634612ae_on
belon73924112belon
beton76022062beton
codon86522852codon
credo84815562credo_
credos94612842credos
crepon1039932crepon
demon86520312demon
devon95113682devon
don46757652__don
ebon66821102_ebon
eon36052082_e_on
exon117116802_exon
felon84619292felon
heron85025502heron
jeon116821442je_on
jeton124815402jeton
lemon75618182lemon
melon73922082melon
meson74118312meson
neon47026422ne_on
odeon6411482odeon
pelon74423212pelon
peon65635242pe_on
racon75422142racon
radons74118522radons
rayon83815702rayon
readorn8310462readorn
reason62616332reason
rebop9313282rebop
reborn810016952reborn
reckon123010542reckon
recoin84320292recoin
recons84922992recons
red46755802red__
redans75421022redans
redbone1037972redbone
redd66323172red_d
redden83613612redden
redds74617832redds
rede55037662red_e
reded74829112reded
redeny102712732redeny
redes65139122redes
redfin10310222redfin
redia65524482redia
redid74922392redid
reding83825562reding
redip87816962redip
redly94217192redly
redock134311542redock
redoes74623752redoes
redoing93516732redoing
redound968172redound
redout71820252redout
redowa1038452redowa
redry94314362redry
reds56042862red_s
redtop937972redtop
redub84212412redub
redux133811102redux
redye94413462redye
region74614902region
reign65015192reign
rein46040892re_in
rejoin134012242rejoin
reloan6415692reloan
reman75730152reman
renin54830032renin
renown9369982renown
repin75324702repin
repo66027542repo_
repos74725792repos
repot75132622repot
reran57329102reran
rerun58722152rerun
resin54131052resin
resod64720052resod
resow88217242resow
resown94112922resown
retorn610923422retorn
rewan85623662rewan
rewin85623962rewin
reworn98122192reworn
rezone153814782rezone
sedan65620422sedan
seton55223542seton
tendon7312032tendon
tenon53320512tenon
udon56017742_udon
uredo65112992uredo_
uredos73910622uredos
xenon122612452xenon

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.1401276364.3
2DLD Change Limit538001031.65632487.9
3Display Results1031030.0137923.1
 (SQL Overall)1786911031.80998778.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.