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

513 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
thegns1054743(None) 
thegn95810901thegn_
theins95015421theins
thens85921831the_ns
hens75642572_he_ns
herns84825582_herns
sheens95116992sheens
teens56227482t_eens
teggs74710742t_eggs
tegs56031492t_eg_s
tens45647412t_e_ns
terns55226872t_erns
thebes115914492thebes
thefts12387922thefts
thegnly1442612thegnly
thein85919022thein_
theine94814922theine
theines104013232theines
theirs94610352theirs
themes115319252themes
then78429692the_n_
theres96525472theres
therms115914872therms
theses96517972theses
thesis94913732thesis
thesps11448262thesps
thetas93011572thetas
thews117416192the_ws
thighs1346632thighs
things104914302things
thins85826332th_ins
thongs104611192thongs
thorns95314102thorns
thugs95611992thug_s
treens65317872treens
tweens9489842tweens
wheens124610612wheens
whens114618762whe_ns
aegis6316783_aegis
aeons57624653_aeons
aligns75312953aligns
amens75624843ame_ns
avens86419333ave_ns
beans75734693_beans
begins94415303_begins
begs75733833_beg_s
bens65945703_be_ns
bhangs12449663bhangs
brens75823363bre_ns
chains114819703chains
changs125215373changs
cheaps134613683cheaps
cheats114519543cheats
checks174912703checks
cheeks154712783cheeks
cheeps135312913cheeps
cheers114518913cheers
chefs136214663che_fs
chegoe1237273chegoe
chegoes1337333chegoes
chelas113817203chelas
chemos13311723chemos
cherts115617233cherts
chess105016923che_ss
chests114916263chests
cheths14389823cheths
chews135418513che_ws
chins105631463ch_ins
chugs115511943chug_s
churns114910233churns
citherns13338873citherns
cleans85817053cleans
coigns94410063coigns
deans66131393_deans
degas75119163_degas
deigns8389983deigns
dens55945073_de_ns
dregs76114863dreg_s
eggs66516153__eggs
egis56520653__egis
egos55821653__egos
engs56121393__engs
ens37245923__e_ns
eons46638713__eons
erns45428223__erns
ethene93312923ethe_ne
ethenes103313873ethenes
ethers94518413ethe_rs
ethions1038483ethions
evens84817103eve_ns
feigns10407753feigns
fens76139763_fe_ns
ferns85220083_ferns
foehns12204973foehns
gens55740073_ge_ns
ghees95215553ghe_es
gleans75014743gleans
glens66519853gle_ns
greens75716873greens
gregos847533gregos
hags86740843_hag_s
hangs95726723_hangs
heads95127113_heads
heals85733453_heals
heaps105223223_heaps
hears86737373_hears
heats85838403_heats
hebes105521673_hebes
hecks145220653_hecks
hedges115016243_hedges
heeds95420423_heeds
heels85625533_heels
hefts116218153_hefts
hehs106723963_he_hs
heils85222193_heils
heirs85618563_heirs
hells85032043_hells
helms105619463_helms
helos84928063_helos
helps105219343_helps
hemes105031083_hemes
hemins113417563_hemins
hemps126917333_hemps
hems95534943_he_ms
hen67555273_he_n_
henge94819823_henge
henges104516453_henges
henna84414043_henna
hennas94211803_hennas
hent76656383_he_nt
hents87330743_hents
herbs105520503_herbs
herds96424683_herds
heres86245903_heres
herls85226433_herls
herms105626433_herms
hern76134893_hern_
herons94820543_herons
heros84930863_heros
hers75844873_he_rs
hes66654203_he__s
hests85829933_hests
heths116317783_heths
hets75547203_he_ts
heughs13516903_heughs
hewn106719853_hewn_
hews105631573_he_ws
hexes155123043_hexes
highs125412523_highs
hins76447993_h_ins
hogans105914313_hogans
hoggs107212463_hoggs
hogs87139663_hog_s
hongs95126203_hongs
hons77350783_h_ons
horns86125333_horns
hugs86129753_hug_s
huns76136933_h_uns
hymns1337523_hymns
jeans126022113_jeans
keens95721183_keens
kegs95824013_keg_s
kens85435233_ke_ns
kerns94719563_kerns
khans124615173kh_ans
khedas1446313khedas
kheths16495973kheths
khets124913433khe_ts
leans55536253_leans
leges64427283_leges
legs56133693_leg_s
lens46146493_le_ns
lieges74113443lieges
liens56525503lie_ns
lutherns1136293lutherns
means75831233_means
megs75530633_meg_s
miens76118303mie_ns
negs55727363_neg_s
negus64513563_negus
neons55818683_neons
oceans81211003oceans
odeons739023odeons
oleins6313523oleins
omegas936973omegas
omens75618963ome_ns
opens76118553ope_ns
others93918003othe_rs
ovens86217453ove_ns
paeans85118263paeans
paeons83915523paeons
peans75437643_peans
peens76428193_peens
pegs75531763_peg_s
peins76128063_peins
pens65649643_pe_ns
peons75327183_peons
phages125213513phages
phlegms1542373phlegms
phons105221143ph_ons
pleons84213343pleons
potheens13266483potheens
preens85020113preens
queans153110753queans
queens15338873queens
querns15307943querns
reges65628783_reges
regna64614813_regna
regs55436573_reg_s
reigns74811753reigns
reins56234563_reins
rheas84816953rhe_as
rhemes115913183rhemes
rhesus936203rhesus
rheums1135463rheums
segni63712483_segni
segno64814743_segno
segnos73610443_segnos
segos64919483_segos
segs54933883_seg_s
shags95123863shag_s
sharns95516983sharns
sheafs124912883sheafs
sheals94420643sheals
shears93820903shears
sheas86331793she_as
sheds96122703she_ds
sheen85023313sheen_
sheeny124912193sheeny
sheers94322403sheers
sheets93918503sheets
sheiks132510013sheiks
shells94319523shells
shend94719973she_nd
shends105313773shends
shent85933503she_nt
sheols94614163sheols
sherds105614723sherds
shes75734353she__s
sheughs14264533sheughs
shewn115715703shewn_
shews115924713she_ws
shins85131043sh_ins
shogis103810943shogis
shogs95319713shog_s
shoguns1134423shoguns
shuns85018143sh_uns
sieges73816833sieges
signs65516323_signs
sithens1039383sithe_ns
skeans104512913skeans
skeens103912913skeens
skegs105011233skeg_s
skeins103911903skeins
speans85417143speans
steins64818343steins
sterns64616763sterns
tabuns8489223tabuns
taels56822073tae_ls
tags55545233t_ag_s
taigas73712563taigas
tains54936323t_ains
takins105117403takins
talons64019433talons
tameins9311413tameins
tangos74216303tangos
tangs65028343tang_s
tans46154823t__ans
targes74524593targes
tarns56433953t_arns
tauons63412673tauons
taverns10317803taverns
taxons134211503taxons
teaks94222903t_eaks
teals56234133t_eals
teams75726513t_eams
tears55436463t_ears
teas45851493t_e_as
teats55636813t_eats
techs106915833t_echs
teds54932573t_e_ds
teeing73916973teeing
teels55726373t_eels
teems76019783t_eems
teen45938203t_een_
teensy9478273t_eensy
teeny85417883t_eeny
tees45353583t_e_es
teffs115111733t_effs
teg45741623t_eg__
tegg65315923t_eg_g
tegua6109563t_egua
teguas768013t_eguas
teind6213613t_eind
teinds738263t_einds
telegas837443telegas
teles54536003t_eles
tells55828943t_ells
telos55424523t_elos
tels46841693t_e_ls
temps95417133t_emps
ten35856113t_e_n_
tend56433773t_e_nd
tends65425583t_ends
tenge65720433t_enge
tennis64015303t_ennis
tenons62916603tenons
tense55225843t_e_nse
tent46159863t_e_nt
tents56434213t_ents
tepas76521683t_epas
terms75523473t_erms
tern46134803t_ern_
terne56426153t_erne
ternes65422903t_ernes
tests56530193t_ests
teths85418513t_eths
tets45847463t_e_ts
tews76431643t_e_ws
texas126514933t_exas
texts125515043t_exts
thacks154311923thacks
than76128773th_an_
thane86122533th_ane
thanes94918983thanes
thank125817803th_ank
thanks134313133thanks
tharms115712243tharms
thaws116515463th_aws
the67436053the___
thebe107515433the_be
theca103311453the_ca
thecae11299653thecae
thecal113310303thecal
thee78039063the__e
theelins1137643theelins
theft114118133the_ft
their85512153the_ir
theism1139483theism
theisms1237763theisms
theist9314763theist
theists1039153theists
them97427043the__m
theme105921733the_me
themed125912583themed
theming133610473theming
thenages12107483thenages
thenal92712423thenal
thenar92610003thenar
thenars10248523thenars
thence112010843thence
theogony1543463theogony
theory121098363theory
there87527393the_re
therians1138313therians
therm106018023the_rm
therme115814993therme
thermes126214613thermes
thermos124610753thermos
these86519013the_se
thesp105410313the_sp
theta83414573the_ta
thetic11412893thetic
thew108226233the__w
thewy146311853the_wy
they107223753the__y
thicks154511993thicks
thieves1346903thieves
thigh12410123thig_h
thills95515383thills
thin76732393th_in_
thine85026863th_ine
thing96622983th_ing
think125018803th_ink
thinks134613363thinks
thiols95112763thiols
thirds10438603thirds
thirls95012063thirls
this76027383th__is
tholes94919783tholes
tholos94213003tholos
thong95014183th_ong
thorn85318703thorn_
thorny12509843thorny
thorons104511913thorons
thorps113610893thorps
thous86017263th_ous
thraws129211103thraws
threads11419953threads
threaps12488643threaps
threats104311673threats
threeps12687043threeps
threes97117323threes
thrips11299013thrips
throbs118311373throbs
throes97518673throes
throne98517603throne
thrones105715843thrones
throng10539973throng
throngs11508163throngs
throws129715233throws
thrums11429123thrums
thuds95110133th_uds
thug86415483thug__
thujas1634433thujas
thumbs13377443thumbs
thumps13449353thumps
thunk124911853th_unk
thunks13459033thunks
thurls9418713thurls
thus76721473th__us
thuyas1234773thuyas
thymes144810743thymes
thymus14324743thymus
tieing73518763tieing
tiepins939463tiepins
tiers55526523tie_rs
ties45248313tie__s
tigers75616513tigers
tigons74112263tigons
tinges74722333tinges
tings65329203ting_s
tins45251303t__ins
titans63414913titans
tmeses85712243tmeses
tmesis8529793tmesis
toeas55726423toe_as
toeing74418473toeing
toes46956443toe__s
togas67823003t_ogas
togs57242433t_og_s
tokens104711563tokens
tolans64319273tolans
tomans85419133tomans
tongas74315523tongas
tongs65928463tong_s
tons46553053t__ons
toons55027533t_oons
toughs105414983toughs
towns86018883t_owns
toxins133314283toxins
toyons95512133toyons
tragus749233tragus
trains64725343trains
trans54933043t_rans
treads74817923treads
treats64821693treats
treen55622753treen_
trees55835763tre_es
treks96016853tre_ks
trend64817453tre_nd
trends75513543trends
trepans92311593trepans
tres46542903tre__s
tress55423163tre_ss
trets55928023tre_ts
trews86118893tre_ws
treys85018213tre_ys
triens65417543triens
trigons84312093trigons
trigos74214173trigos
trigs65423063trig_s
trogons83410723trogons
trogs67022603trog_s
trugs65516803trug_s
tugs56231673t_ug_s
tungs65520623tung_s
tuns45138663t__uns
tureens7289873tureens
turns55623233t_urns
twains95811183twains
twangs10358093twangs
tweaks1335963tweaks
tweeds10498433tweeds
tween84413743tween_
tweeny12477003tweeny
tweets94210103tweets
twerps11345153twerps
twigs96911173twig_s
twins85118983t_wins
tyees86019453tye_es
tyers86220053tye_rs
tyes76433373tye__s
uhlans937573uhlans
vegans103910853_vegans
veges94118863_veges
veins84620493_veins
weans85326743_weans
weens85224053_weens
wens76337933_we_ns
whangs13439723whangs
wheals124512523wheals
wheats125013223wheats
wheels123811713wheels
wheen115016053wheen_
wheeps14439953wheeps
whelks16367323whelks
whelms14377573whelms
whelps14437843whelps
when105723043whe_n_
whenas124610463whenas
wheres125917433wheres
whets115019613whe_ts
whews145114493whe_ws
wheys145911553whe_ys
whigs125612643whig_s
whins114922333wh_ins
wrens85016243wre_ns
yeans86624883_yeans
yeggs10608163_yeggs
yens75832263_ye_ns
zeins144715393_zeins
zitherns20376133zitherns

Search took 5 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.1231452772.4
2DLD Change Limit1127165134.61024450.3
3Display Results5135130.1563288.5
 (SQL Overall)1786915134.88936549.6
 
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.