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

106 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
codons9611946(None) 
codens94821011codens
codon86522851codon_
cogons96818111cogons
colons86028681colons
coons76737281co_ons
cordons104415761cordons
boons75031912bo_ons
borons85520542borons
bosons85016652bosons
canons85522062canons
capons104119502capons
cardons104519932cardons
cions75222852c_ions
clons75228132c_lons
cocoas104915742cocoas
cocoons11310562cocoons
cocos95624692coco_s
codas84724242cod_as
codecs115112932codecs
codeins103715482codeins
coden86128542coden_
coders95426982coders
codes86247292cod_es
coding104024792coding
codlins104116242codlins
cods76848102cod__s
cogon89120902cogon_
cohogs125810272cohogs
cohos105921852coho_s
coigns94410062coigns
coins75834552co_ins
cojoins1638992cojoins
cojones163512102cojones
colins85229042colins
cologs96517352cologs
colon78630192colon_
colone85425002colone
colones96124432colones
coloni85619202coloni
colonus94413442colonus
colony115417272colony
colors86622372colors
commons13311042commons
comous10816502comous
condoes104319202condoes
condoms124214082condoms
condone102616292condone
condones112817392condones
condors104018572condors
condos94322332condo_s
conins84327232conins
conns75024232co_nns
cons66057692c__ons
coofs105924712co_ofs
cooks115429142co_oks
cools75632632co_ols
coon67248942co_on_
coops96229642co_ops
coos67456492co_o_s
coots75636842co_ots
copens106119962copens
cordon95017292cordon_
corns76034762co_rns
corona83817402corona
coronas93916912coronas
cotans81317922cotans
cottons9312192cottons
coupons112710562coupons
covens114919262covens
covins114618062covins
coydogs1434492coydogs
cozens176314922cozens
croons85418422croons
crotons93714372crotons
cytons111710182cytons
dodoes85716102dodoes
dodos75819392dodo_s
dons56048702__dons
godowns1234672godowns
godsons966662godsons
goons65326772go_ons
iodins74216522iodins
iodous7311502iodous
lodens74315062lodens
logons79818172logons
loons55731722lo_ons
moons75331002mo_ons
morons84919542morons
nodous7711332nodous
noons54125282no_ons
odeons739022_odeons
odors64514282_odors
poons75430972po_ons
radons74118532radons
redons75222182redons
sodoms989672sodoms
solons65120022solons
toons55027532to_ons
toyons95512132toyons
udons65411462_udons
vodouns1134762vodouns
vodous1038602vodous
voduns1035052voduns
voudons1135322voudons
zoons144919692zo_ons

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit825511062.44033832.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911062.81263545.9
 
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.