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 “exons” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
exons12581334(None) 
axons125517931axons
ebons74316091ebons
eons46638711e_ons
exon117116801exon_
aeons57624652aeons
agons66423782agons
axions134713482axions
axon115524302axon_
axone125918472axone
axones134614512axones
azons146518252azons
belons84119412belons
betons84919552betons
boons75031912boons
cions75222852cions
clons75228132clons
cons66057692_cons
coons76737282coons
demons94917722demons
devons104512252devons
dons56048702_dons
earns55927562earns
ebon66821102ebon_
ebony104511512ebony
egos55821652ego_s
eikons1038502eikons
elans55527752elans
eloins65419382eloins
enols54718402enols
enows85115492enows
ens37245922e__ns
eon36052082e_on_
epos66723732epo_s
erns45428222e_rns
eros45238452ero_s
evens84817102evens
exams14199082exams
execs14539722execs
exes116530812ex_es
exine125518492exine
exines135715802exines
exing136016812exing
exits125515912exits
exodos1435942exodos
exodus1434652exodus
exogens1536882exogens
exonic153211412exonic
exonym1844582exonym
exonyms1944432exonyms
expos1449202expos
extols1337682extols
felons93615762felons
fons76943892_fons
frons86124042frons
goons65326772goons
herons94820542herons
hexone16289232hexone
hexones17299142hexones
hons77350782_hons
icons76516492icons
ikons96311012ikons
ions46737852_ions
irons55324132irons
jetons134512612jetons
kaons95014852kaons
lemons84415052lemons
lions55923212lions
loons55731722loons
melons84117712melons
mesons83215842mesons
mons68152252_mons
moons75331002moons
muons75816172muons
neons55818682neons
noons54125282noons
ons36148512__ons
peons75327182peons
phons105221142phons
pions75826392pions
pons65850602_pons
poons75430972poons
recons84922992recons
redons75222182redons
setons64620172setons
sextons143710412sextons
sons46049552_sons
taxons134211502taxons
tenons62916602tenons
tons46553052_tons
toons55027532toons
udons65411462udons
wons74942042_wons
xenons132710482xenons
zoons144919692zoons

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.0961861364.6
2DLD Change Limit53800951.45037103.4
3Display Results95950.0332878.8
 (SQL Overall)178691951.579113167.2
 
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.