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

113 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
recon7562424(None) 
racon75422141racon
reckon123010541reckon
recoin84320291recoin
recons84922991recons
redon65424881redon
rewon86920571rewon
aeon45634612ae_on
ancon75718232ancon
bacon95620592bacon
beacon10511372beacon
beckon14309382beckon
belon73924112belon
beton76022062beton
con510268022__con
crepon1039932crepon
deacon9510422deacon
deco76125972deco_
decor84717572decor
decos85522122decos
decoy115716312decoy
demon86520312demon
devon95113682devon
ebon66821102_ebon
eon36052082_e_on
exon117116802_exon
felon84619292felon
heron85025502heron
icon66922042_icon
jeon116821442je_on
jeton124815402jeton
lemon75618182lemon
macon94519952macon
melon73922082melon
meson74118312meson
neocon836712neocon
neon47026422ne_on
pecan91919032pecan
pelon74423212pelon
peon65635242pe_on
racons84319342racons
racoon83814472racoon
radon64620502radon
rayon83815702rayon
reason62616332reason
rebop9313282rebop
reborn810016952reborn
rec55645462rec__
recane83022872recane
recant83228682recant
recap95718022recap
recce9514562recce
recent83630852recent
recit75235102recit
reck106130562rec_k
reckons13269652reckons
recks115625132recks
recoal84117972recoal
recoat84024272recoat
recock145112722recock
recode93618712recode
recoil84016722recoil
recoins94019242recoins
recomb1238872recomb
recook125513922recook
recopy1339042recopy
record96117422record
recork126315482recork
recount9315172recount
recoup10810372recoup
recrown12257572recrown
recs65734182rec_s
recta74220262recta
recti73619622recti
recto74520802recto
rector84019742rector
rectos85718782rectos
recur74116842recur
recut74729242recut
redan66125012redan
redo56029362redo_
redone74820052redone
redons75222182redons
redos65126762redos
redox134714232redox
region74614902region
reign65015192reign
rein46040892re_in
rejoin134012242rejoin
reloan6415692reloan
reman75730152reman
renin54830032renin
renown9369982renown
repin75324702repin
repo66027542repo_
repos74725792repos
repot75132622repot
reran57329102reran
rerun58722152rerun
resin54131052resin
resod64720052resod
resow88217242resow
resown94112922resown
retorn610923422retorn
rewan85623662rewan
rewin85623962rewin
reworn98122192reworn
rezone153814782rezone
ricin74620212ricin
second9411152second
seton55223542seton
tenon53320512tenon
xenon122612452xenon

Search took 5 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.190940478.9
2DLD Change Limit538001134.04613297.1
3Display Results1131130.0631793.7
 (SQL Overall)1786911134.29941565.7
 
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.