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

152 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
techno113595(None) 
technos1236181technos
echo96615952_ech_o
tech95925442tech__
teched124014432teched
techie11511722techie
technic1496902technic
techs106915832tech_s
techy135612012tech_y
achoo10315083_achoo
ahchoo1445713ahchoo
ancho104515303anch_o
archon11311753archon
atechnic1554403atechnic
beano75421553be_ano
beckon14309383beckon
chao95727313__chao
chino105823313__chino
chon96627793__chon
decane93818873decane
decant93524223decant
decent94023703decent
deco76125973dec__o
eche97520283_ech_e
eched116919223_eched
eches106322163_eches
eching126315563_eching
echini114710433_echini
echos105216463_echos
echt95722903_ech_t
etch95419143etch__
etchant1249823etchant
etched123613703etched
etcher113912943etcher
etches114217763etches
etching134511843etching
ethnos947053_ethnos
fecund1235433fecund
gecko124511113gec_ko
keno87926433ke__no
kerchoo1644973kerchoo
lech96825443lech__
leched123716003leched
lecher113415853lecher
leches115421313leches
leching134613653leching
lechwe1435113lechwe
leno47331393le__no
macho126120153mach_o
meno66031363me__no
merino8315093merino
mucho125013443much_o
nacho105414383nach_o
outecho1244893outech_o
pecan91919033pecan_
pecans101515833pecans
pech116125453pech__
pechan13511543pechan
pechans14810503pechans
peched144915343peched
peching154513903peching
pechs125516203pech_s
pepino10310333pepino
recane83022873recane
recant83228683recant
recent83630853recent
rechew14310213rechew
reckon123010543reckon
recon75624243recon_
recons84922993recons
recto74520803rec_to
reecho11318653reech_o
schmo124510203_schmo
schnoz2035653_schnoz
secant84023293secant
secco9312423sec_co
second9411153second
secondo1044933secondo
secund937103secund
segno64814743se_gno
steno54716863ste__no
tach96132753tach__
tache106222373tach_e
taches114224173taches
tachs105820933tach_s
tachyon1544623tachyon
taco67031353tac__o
teach105221123teach__
teacher123714833teacher
teaches122718353teaches
teaching143612603teaching
techier1269243techier
techies12513603techies
techily1537123techily
technics1585463technics
technopop1851993technopop
tecta74215523tec_ta
tectal83713253tectal
tectum10328603tectum
teeing73916973teeing
teen45938203te_en_
teens56227483te_ens
teeny85417883te_eny
teflon937453teflon
teind6213613te_ind
telco7511873te_lco
telson6310293telson
tempo95214973te_mpo
ten35856113te__n_
tenant6322473tenant
tench105620003tench__
tenches123515523tenches
tend56433773te__nd
tendon7312033tendon
tenon53320513te__non
tenons62916603tenons
tenor53620253te__nor
tens45647413te__ns
tent46159863te__nt
tenuto648743tenuto
tephra1136483tephra
teredo7310783teredo
tern46134803te_rn_
terne56426153te_rne
terns55226873te_rns
teston6313303teston
tetany959843tetany
tetched133010773tetched
tetchy1436003tetch_y
teth76327893teth__
tether93716103tether
teths85418513teth_s
teuch105214853teuch__
tewing103914823tewing
thio77225413t__hio
tho67433963t__h_o
thro77726423t__hro
tocher114014913tocher
torchon1237363torchon
trecento1066213trecento
tuchun1145443tuchun
tuchuns1233983tuchuns
tycoon1136023tycoon
typhon1436673typhon
wecht13415443wech_t
wechts1446253wechts
yech127220533yech__
yechs136112583yech_s
yechy16519083yech_y
zecchino2442663zecchino
zechin20137703zechin
zechins21137123zechins

Search took 6 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 Filter1786911127160.403443402.0
2DLD Change Limit1127161525.44020719.9
3Display Results1521520.0602533.3
 (SQL Overall)1786911525.90330271.2
 
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.