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

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

192 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
thens8592183(None) 
hens75642571_hens
teens56227481teens
tens45647411t_ens
thegns10547431thegns
theins95015421theins
then78429691then_
thews117416191thews
thins85826331thins
whens114618761whens
amens75624842amens
avens86419332avens
bens65945702_bens
brens75823362brens
chefs136214662chefs
chess105016922chess
chews135418512chews
chins105631462chins
dens55945072_dens
ens37245922__ens
ethene93312922ethene
ethenes103313872ethenes
ethers94518412ethers
evens84817102evens
fens76139762_fens
gens55740072_gens
ghees95215552ghees
glens66519852glens
hehs106723962_hehs
hems95534942_hems
hen67555272_hen_
hent76656382_hent
hents87330742_hents
herns84825582_herns
hers75844872_hers
hes66654202_he_s
hets75547202_hets
hews105631572_hews
hins76448002_hins
hons77350782_hons
huns76136932_huns
keens95721182keens
kens85435242_kens
khans124615172khans
khets124913432khets
lens46146492_lens
liens56525502liens
miens76118302miens
omens75618962omens
opens76118552opens
others93918002others
ovens86217452ovens
peens76428192peens
pens65649642_pens
phons105221142phons
rheas84816952rheas
sheas86331792sheas
sheds96122702sheds
sheens95116992sheens
shend94719972shend
shends105313772shends
shent85933502shent
shes75734352she_s
shews115924712shews
shins85131042shins
shuns85018142shuns
sithens1039382sithens
taels56822072taels
tains54936322tains
tans46154832t_ans
tarns56433952tarns
teas45851492t_eas
teds54932582t_eds
teels55726372teels
teems76019782teems
teen45938202teen_
teensy9478272teensy
teeny85417882teeny
tees45353582t_ees
tegs56031492t_egs
tels46841692t_els
ten35856112t_en_
tend56433772t_end
tends65425582t_ends
tense55225842t_ense
tent46159862t_ent
tents56434212t_ents
terns55226872terns
tets45847462t_ets
tews76431642t_ews
than76128772than_
thane86122532thane
thanes94918982thanes
thank125817802thank
thanks134313132thanks
thaws116515462thaws
the67436052the__
thebe107515432thebe
thebes115914492thebes
theca103311452theca
thee78039062the_e
theft114118132theft
thefts12387922thefts
thegn95810902thegn
thein85919022thein
theine94814922theine
theines104013232theines
their85512152their
theirs94610352theirs
theism1139482theism
theist9314762theist
them97427042the_m
theme105921732theme
themes115319252themes
thenal92712432thenal
thenar92610002thenar
thenars10248522thenars
thence112010852thence
there87527392there
theres96525472theres
therm106018022therm
therms115914872therms
these86519012these
theses96517972theses
thesis94913732thesis
thesp105410312thesp
thesps11448262thesps
theta83414572theta
thetas93011572thetas
thew108226232the_w
thewy146311852thewy
they107223752the_y
thin76732392thin_
thine85026862thine
thing96622982thing
things104914302things
think125018802think
thinks134613362thinks
this76027382th_is
thong95014182thong
thongs104611192thongs
thorns95314102thorns
thous86017262thous
threes97117322threes
thuds95110132thuds
thugs95611992thugs
thunk124911852thunk
thunks13459032thunks
thus76721472th_us
tiers55526522tiers
ties45248322tie_s
tines54848422tines
tins45251312t_ins
toeas55726422toeas
toes46956442toe_s
tokens104711562tokens
tones56048662tones
tons46553052t_ons
toons55027532toons
towns86018882towns
trans54933042trans
treens65317872treens
trees55835762trees
treks96016852treks
trend64817452trend
trends75513542trends
tres46542902tre_s
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
triens65417542triens
tunes55332192tunes
tuns45138662t_uns
turns55623242turns
tweens9489842tweens
twins85118982twins
tyees86019452tyees
tyers86220052tyers
tyes76433372tye_s
tynes85920302tynes
weens85224052weens
wens76337932_wens
wheens124610612wheens
when105723042when_
whenas124610462whenas
whets115019612whets
whews145114492whews
wheys145911552wheys
whins114922332whins
wrens85016242wrens
yens75832262_yens

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001921.57634137.1
3Display Results1921920.0633047.6
 (SQL Overall)1786911921.95291542.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.