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

382 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
thenar9261000(None) 
thenal92712421thenal
thenars10248521thenars
denar65223292_denar
hear76143882_he_ar
shear85424832she_ar
tear45242882t_e_ar
teener64717502teener
tenor53620252t_enor
theca103311452theca_
thecae11299652thecae
thecal113310302thecal
their85512152the_ir
then78429692then__
thenage11107842thenage
thence112010842thence
thens85921832then_s
theta83414572theta_
thetas93011572thetas
whenas124610462whenas
acinar8310483acinar
ahead96817053ahe_ad
alegar739283alegar
anear55420323ane_ar
arena55323813arena_
arenas65021993arenas
bear66844643_be_ar
blear75918683ble_ar
caesar8410933caesar
cedar84014323_cedar
chadar1239353chadar
char95132153ch__ar
cheap126915943che_ap
cheat105732453che_at
cheddar14254733cheddar
cheder125113493cheder
cheer105420383che_er
chela103916803chela_
chelae113614603chelae
chelas113817203chelas
chetah14399583chetah
chewer145512623chewer
chimar133911473chimar
china105022483china_
chinas115119403chinas
chukar1534633chukar
clear76219053cle_ar
dear55343603_de_ar
debar85517863_debar
denari710917353_denari
denars74621433_denars
denary105316863_denary
dewar95817733_dewar
dinar66319893_dinar
drear65016903dre_ar
ear36867883__e_ar
ethene93312923ethen_e
ethenes103313873ethenes
ether84518773ethe__r
evener91010623evener
eyebar1135323eyebar
faena85014203faena_
faenas94412763faenas
fear75337793_fe_ar
feuar8310243_feuar
frena85915273frena_
gear55934973_ge_ar
gherao1036753gherao
gnar56021383__gnar
haar77323493_h_aar
hangar104114513_hangar
head87137173_he_ad
heal75645693_he_al
heap96432893_he_ap
heard95222753_he_ard
hears86737373_he_ars
heart85440743_he_art
heat77061423_he_at
heder95623643_heder
hegari1039523_hegari
heir77523803_he_ir
hemal104419803_hemal
hen67555273_hen__
hence104920043_hence
henge94819833_henge
henna84414043_henna
hennas94211803_hennas
henry114014473_henry
hens75642573_hen_s
hent76656383_hen_t
hents87330743_hents
her66547813_he__r
hewer115719933_hewer
hexad164910623_hexad
hexer155116683_hexer
hilar85418143_hilar
hoar76729163_h_oar
honan85319773_honan
honer85332093_honer
honor85718623_honor
hyena11810253hyena_
hyenas1288953hyenas
ither84617603ithe__r
kebar115113533_kebar
keener104012843keener
kenaf12316033_kenaf
kheda1346533kheda_
khedah1743643khedah
khedas1446313khedas
knar85818723__knar
lear47045953_le_ar
lienal63912783lienal
linear65113343linear
lunar57017313_lunar
maenad939413maenad
menad85918983_menad
near45236503_ne_ar
opener83910993opener
other84219103othe__r
outhear10910603outhe_ar
pear69745233_pe_ar
penal75228373_penal
phenate12412203phenate
phenix1837133phenix
phenol1149253phenol
phenom1339473phenom
phenyl1435323phenyl
phonal11310383phonal
phylar14437373phylar
planar84212713planar
plena75816393plena_
plenary1237543plenary
prewar114712583prewar
rear45644553_re_ar
rebar75420193_rebar
rehear93713223rehear
renal55929503_renal
rhea75017433rhe_a_
rheas84816953rhe_as
rhetor938063rhetor
rhinal9510193rhinal
scena74815783scena_
scenas84114703scenas
sear47353843_se_ar
senary93716073_senary
senor53822803_senor
sewar85421103_sewar
shea76031573she_a_
sheaf115424123she_af
sheal84927703she_al
shears93820903she_ars
sheas86331793she_as
sheer84726893she_er
shend94719973shen_d
shends105313773shends
shent85933503shen_t
shewer124515113shewer
shikar1336803shikar
shiner93820873shiner
shmear1176933shmear
shofar1236313shofar
smear74416393sme_ar
sonar56523423_sonar
spear75821063spe_ar
stelar64013863stelar
sthenia1058503sthenia
sthenias1178163sthenias
sthenic1268903sthenic
swear85316853swe_ar
taenia6313193taenia
taeniae739083taeniae
taenias7311283taenias
talar56225383t_alar
tanner63722283tanner
tar37570693t___ar
tarnal63716503tarnal
tartar63214753tartar
tatar56122063t_atar
tea37353323t_e_a_
teak85930843t_e_ak
teal45546503t_e_al
team66238653t_e_am
tears55436463t_e_ars
teary85124053t_e_ary
teas45851493t_e_as
teat45963633t_e_at
teemer85515743teemer
teen45938203teen__
teenage8108053teenage
teenager9115293teenager
teeners74415453teeners
teenier72611143teenier
teens56227483teen_s
teensy9478273teensy
teeny85417883teen_y
teeter65420313teeter
tela45532973t_ela_
telae54323293t_elae
ten35856113t_en__
tenace82715693t_enace
tenail64516113t_enail
tenant6322473t_enant
tench105620003t_ench
tend56433773t_en_d
tender74121843t_ender
tends65425583t_ends
tendu67216003t_endu
tenet55542213t_enet
tenge65720443t_enge
tenia55324483t_enia
teniae64517353t_eniae
tenias64720073t_enias
tenner64117103tenner
tenon53320513t_enon
tenors63217753t_enors
tenour62610733t_enour
tens45647413t_en_s
tense55225843t_ense
tenser64919433t_enser
tensor63812673t_ensor
tent46159863t_en_t
tenter64623933t_enter
tenth85421833t_enth
tents56434213t_ents
tenty86121603t_enty
tenure6311613t_enure
tepa66021683t_epa_
tepal76319583t_epal
tepas76521683t_epas
terai53525483t_erai
ternary1038343ternary
terra54419663t_erra
tetra53417953t_etra
texas126514933t_exas
thae76825563th__ae
thaler94613103thaler
than76128773th__an
thanage11117943thanage
thane86122533than_e
thanes94918983thanes
thank125817803than_k
thanker14309593thanker
thanks134313133thanks
tharm105916643th__arm
that75639323th__at
thaw107521313th__aw
thawer12489343thawer
the67436053the___
theater104014253theater
theatre10358493theatre
thebe107515433the_be
thebes115914493thebes
thecate123210023thecate
thee78039063the__e
theft114118133the_ft
thefts12387923thefts
thegn95810903the_gn
thegnly1442613thegnly
thegns10547433thegns
thein85919023the_in
theine94814923theine
theines104013233theines
theins95015423theins
theirs94610353theirs
theism1139483theism
theist9314763theist
them97427043the__m
theme105921733the_me
themed125912583themed
themes115319253themes
thenages12107483thenages
theory121098363theory
therapy1536613therapy
there87527393the_re
thereat104315243thereat
theres96525473theres
theriac1239143theriac
therian10311293therian
therm106018023the_rm
thermae125310503thermae
thermal125010973thermal
therme115814993therme
therms115914873therms
thesauri1152563thesauri
these86519013the_se
theses96517973theses
thesis94913733thesis
thesp105410313the_sp
thesps11448263thesps
thetic11412893thetic
thew108226233the__w
thewier1336063thewier
thews117416193the_ws
thewy146311853the_wy
they107223753the__y
thin76732393thin__
thine85026863thin_e
thing96622983thin_g
things104914303things
think125018803thin_k
thinker143610683thinker
thinks134613363thinks
thinly1238673thinly
thinner10358973thinner
thins85826333thin_s
thir76420543th__ir
thiram1139963thiram
thong95014183thon_g
thongs104611193thongs
thorax1638253thorax
thraw1110515923th_raw
thread105011093thread
threap11569663threap
threat95020463threat
throat94819753throat
thuja1535213thuja_
thujas1634433thujas
thunder1136963thunder
thunk124911853thun_k
thunks13459033thunks
thuya1135583thuya_
thuyas1234773thuyas
thwart12311683th_wart
tier44936143tie__r
tinea54923163tinea_
tineal66216163tineal
tineas64616483tineas
tinner64119963tinner
toea46732333toe_a_
toeas55726423toe_as
toecap1037323toecap
toenail738783toenail
tolar55524113t_olar
tonal53724303t_onal
tonearm937443tonearm
toner55336243t_oner
tonner64819203tonner
tread64821703tre_ad
treat56240353tre_at
trefah1235093trefah
tremor84210403tremor
trenail7410813trenail
trench114211613trench
trend64817453tren_d
trends75513543trends
trendy10469603trendy
trepan82511673trepan
trinal6516963trinal
trinary1039173trinary
trocar848773trocar
trona54118953trona_
tronas63816903tronas
tsar47819803t__sar
tuna45127843t_una_
tunas54224123t_unas
tuner56022683t_uner
turner63914613turner
tussar6369543tussar
tutelar735373tutelar
tweak1257753twe_ak
tweener10306833tweener
twenty1236223twenty
twiner94012593twiner
tyer75323393tye__r
typebar1442993typebar
tzar136315373t__zar
ulnar56013983_ulnar
veena81912323veena_
veenas91410413veenas
velar85817633_velar
vena76126293_vena_
venae85920983_venae
venal85523213_venal
wear75836723_we_ar
wheal115716183whe_al
wheat114924573whe_at
when105723043when__
whence14187923whence
whens114618763when_s
whiner124516633whiner
wiener94513543wiener
year76534253_ye_ar

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.390458182.1
2DLD Change Limit1127163824.78323566.0
3Display Results3823820.1233105.7
 (SQL Overall)1786913825.29633740.7
 
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.