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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
technos123618(None) 
techno1135951techno_
echos105216462_ech_os
ethnos947052_ethnos
techies12513602techies
technic1496902technic
technics1585462technics
techs106915832tech__s
anchos114214893anch_os
archons12311583archons
atechnic1554403atechnic
beanos85516513be_anos
beckons15279143beckons
chaos105622863__chaos
chinos115018693__chinos
decanes103118913decanes
decants103514443decants
decos85522123dec__os
eches106322163_ech_es
echinus1236203_echinus
echo96615953_ech_o_
echoes114715523_echoes
etchants1346023etchants
etchers123411293etchers
etches114217763etch_es
etchings14396293etchings
ethos85514193_eth_os
geckos13457433gec_kos
kenos95220623ke__nos
lechers123313963lechers
leches115421313lech_es
lechwes1535063lechwes
lenos56024863le__nos
lychnis1544383lychnis
machos135217493mach_os
merinos9311983merinos
nachos115014183nach_os
pecans101515833pecan_s
pechans14810503pechans
pechs125516203pech__s
pepinos1137693pepinos
recanes93222263recanes
recants93217093recants
rechews1537293rechews
rechoose13137353rechoose
rechose121312053rech_ose
reckons13269653reckons
recons84922993recon_s
rectos85718783rec_tos
schmos13379153_schmos
schnoz2035653_schnoz
secants93413893secants
seccos1039923sec_cos
seconds1038283seconds
segnos73610443se_gnos
stenos63915773ste__nos
taches114224173tach_es
tachs105820933tach__s
tachyon1544623tachyon
tachyons1644623tachyons
tacos77023553tac__os
teachers133212393teachers
teaches122718353teach_es
teachings15296553teachings
tech95925443tech___
teched124014433tech_ed
techie11511723tech_ie
techier1269243techier
techiest1359833techiest
techily1537123techily
technopop1851993technopop
technopops1952073technopops
techy135612013tech__y
tectums11306423tectums
teens56227483te_en_s
teflons1036543teflons
teinds738263te_inds
telcos8710683te_lcos
telos55424523te__los
telsons739223telsons
tempos103812293te_mpos
tenants7311013tenants
tenches123515523tench_es
tendons8311473tendons
tends65425583te__nds
tennis64015303te_nnis
tenon53320513te__non
tenons62916603te__nons
tenor53620253te__nor
tenors63217753te__nors
tens45647413te__n_s
tents56434213te__nts
tenutos736623tenutos
tephras1236283tephras
teredos839183teredos
ternes65422903te_rnes
terns55226873te_rn_s
testons7313563testons
tetanus737933tetanus
tethers103815313tethers
teths85418513teth__s
tochers123413093tochers
torchons1337503torchons
trecentos1155873trecentos
tuchuns1233983tuchuns
tycoons1235173tycoons
typhons1537083typhons
wechts1446253wech_ts
yechs136112583yech__s
zecchinos2541723zecchinos
zechins21137123zechins

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271116.73619897.1
3Display Results1111110.0303700.0
 (SQL Overall)1786911117.16924925.5
 
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.