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

253 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
tetchy143600(None) 
techy135612011te_chy
beachy164011252beachy
beechy16397502beechy
bitchy16479202bitchy
botchy16537822botchy
catchy16559582catchy
etch95419142_etch_
fetch134913472fetch_
fitchy17437622fitchy
itchy13449012_itchy
ketch144912022ketch_
kvetchy2241802kvetchy
leachy14419732leachy
letch105215802letch_
patchy16509572patchy
peachy164510842peachy
pitchy16479672pitchy
reechy14367822reechy
retch104818302retch_
sketchy1943052sketchy
stenchy15256212stenchy
stretchy1644082stretchy
teach105221122teach_
tech95925442te_ch_
techs106915832te_chs
tench105620002tench_
tetany959842tetany
tetched133010772tetched
tetchily1644122tetchily
teth76327892tet_h_
teths85418512tet_hs
teuch105214852teuch_
thatchy1833302thatchy
torchy14549532torchy
touchy145010502touchy
twitchy18393572twitchy
vetch134411842vetch_
witchy17468592witchy
yechy16519082ye_chy
achy126316093__achy
aitch105216163aitch_
batch124620103batch_
beach124623893beach_
beech124315503beech_
belch124415503belch_
bench125619503bench_
beth96629233bet_h_
beths105519223bet_hs
betony114211583betony
betray111511443betray
bitch125017763bitch_
blotchy17293973blotchy
botch126717453botch_
bothy136713963bot_hy
bunchy16437463bunchy
butch125416543butch_
catch125120373catch_
clutchy17323893clutchy
conchy163710223conchy
cutch125116193cutch_
datcha1266563datcha
deathy134210233deathy
decay114718483de_cay
decoy115716313de_coy
decry115514353de_cry
descry1256183descry
detach12310413detach_
ditch115015093ditch_
duchy144310873_duchy
dutch114713823dutch_
each95530583_each_
eche97520283_e_che
echo96615953_e_cho
echt95722903_e_cht
etched123613703_etched
etcher113912943_etcher
etches114217763_etches
eth66630983_et_h_
eths76619523_et_hs
ethyl1136513_et_hyl
fetched163710473fetched
fetcher153510393fetcher
fetches153413893fetches
fetich1479693fetich_
fitch134816873fitch_
fletch14388193fletch_
glitchy16283083glitchy
gotcha1234633gotcha
hatch135719593hatch_
heathy156111213heathy
heth107028023het_h_
heths116317783het_hs
heuch135312333heuch_
heuchs14447923heuchs
hitch134515473hitch_
hotch136214733hotch_
hutch135414093hutch_
itch95619173_itch_
jetty156212583jet_ty
jetway19105273jetway
kench145513923kench_
ketches164012193ketches
ketchup1842783ketchup
kitschy1941983kitschy
kvetch1832993kvetch_
latch104620463latch_
lathy115215063lat_hy
leach105422523leach_
lech96825443le_ch_
leech104913213leech_
letched133912053letched
letches124015483letches
lethe85717303let_he
litchi1137893litchi
match125621103match_
menschy17354003menschy
merch125417963merch_
mercy125916183merc_y
meshy135612783me_shy
meth95827843met_h_
meths105320233met_hs
methyl1436403met_hyl
mothy136214553mot_hy
mutch125016173mutch_
mythy16568673myt_hy
natch105018223natch_
nettly9459453nettly
netty85816763net_ty
notch105613323notch_
outcry1137993outcry
patch125221223patch_
peach125422493peach_
pech116125453pe_ch_
pechs125516203pe_chs
pecky165515093pe_cky
perch124518833perch_
petty105320293pet_ty
pitch125018413pitch_
pithy135614463pit_hy
poachy16388963poachy
pouchy16538663pouchy
preachy17307313preachy
punchy16398523punchy
ratch104221363ratch_
reach105123883reach_
reecho11318653reecho
retched133814273retched
retches123318513retches
retry84718083ret_ry
rotch105815933rotch_
rotche114311983rotche
seiche11811833seiche
sketch1535363sketch_
smutchy17193153smutchy
snatchy15355293snatchy
starchy15286743starchy
stench114111163stench_
stitch11419103stitch_
stithy12398213stit_hy
stretch1236413stretch_
tach96132753t_ach_
tache106222373t_ache
tachs105820933t_achs
tacky145617443t_acky
talcky15294723talcky
tatty84720183tat_ty
teacher123714833teacher
teaches122718353teaches
teacup1036253teacup
teapoy1138113teapoy
teary85124053te_ary
teched124014433te_ched
techie11511723te_chie
techily1537123te_chily
techno1135953te_chno
tecta74215523te_cta
tectal83713253tectal
tectum10328603tectum
teddy10489493te_ddy
teensy9478273teensy
teeny85417883te_eny
teeth87315853teeth_
teethe94511313teethe
telco7511873telc_o
telcos8710683telcos
telly84920823te_lly
tenches123515523tenches
tenth85421833tenth_
tenthly1335743tenthly
tenths94412663tenths
tenty86121603te_nty
tepefy1434803tepefy
tepoy10312163te_poy
terce75721843terc_e
tercel83612993tercel
terces83921413terces
tercet83624913tercet
termly1138433termly
terry84721873te_rry
testacy1235963testacy
testify13246943testify
testily102910803testily
testy85419063te_sty
tet39274993tet___
tetchier1336453tetchier
tether93716103tether
tetra53417953tet_ra
tetrad73612053tetrad
tetrarchy17103333tetrarchy
tetras63017623tetras
tetri52716453tet_ri
tetris62816293tetris
tetryl935693tetryl
tets45847463tet__s
tetter64322453tetter
teugh95511613teugh_
teughly14443433teughly
thatch1435613thatch_
thearchy1943443thearchy
thy97022913__t_hy
tithe85319703tit_he
titty85316653tit_ty
toothy12529693toothy
torch107420933torch_
touch106519393touch_
touche114916173touche
toughy135911073toughy
trashy12509053trashy
treacly1237093treacly
trench114211613trench_
tricky154211473tricky
troche113112513troche
trophy1438283trophy
tusche1136783tusche
tushy114212993t_ushy
tutty85217023tut_ty
twitch14406163twitch_
tythe115210453tyt_he
vetches153411263vetches
vichy1639043_vichy
watch135617063watch_
wecht13415443we_cht
welch134411493welch_
wench136214783wench_
wetly114511713wet_ly
witch134517563witch_
withy144813763wit_hy
wretch14326533wretch_
yecch15558093yecch_
yecchs16414953yecchs
yech127220533ye_ch_
yechs136112583ye_chs

Search took 7 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.406440125.6
2DLD Change Limit1127162535.50020493.8
3Display Results2532530.0803162.5
 (SQL Overall)1786912535.98629851.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.