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

241 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
tennist7281311(None) 
tennis64015301tennis_
tennists8297791tennists
bennis84314802bennis_
dentist8316742dentist
enlist6417042_enlist
fenniest113113202fenniest
hennish1336862hennish
pennis84315742pennis_
sennit63117922senni_t
sennits73811282sennits
tanist6324592t_anist
tannest72617852tannest
tannish101610572tannish
teeniest82112412teeniest
tennies73017972tennies
tennises82810132tennises
tenorist8413022tenorist
tensest72713312tensest
tentiest82115612tentiest
tenuis64213082tenuis_
tinniest82911462tinniest
tonnish10149092tonnish
wenniest11259592wenniest
wennish1336242wennish
agonist82615403agonist
anenst63514983anen_st
bemist105216963be_mist
bendiest112311983bendiest
bennes86019013bennes_
bennet84823363benn_et
bennets94712163bennets
benni74715363benni__
bennies93917313bennies
bonniest10310773bonniest
bundist10310193bundist
canniest10313363canniest
canonist10513533canonist
cellist9314423cellist
centrist10314863centrist
consist9316033consist
deist64633593de__ist
delist74625053de_list
demonist11413473demonist
denning93515173denning
densest83112473densest
dentists939263dentists
desist74818813de_sist
detentist1049323detentist
donnish11187633donnish
dunnest83312263dunnest
egoist7612283_egoist
encyst1136203_encyst
engirt71112613_engirt
enlists749393_enlists
ennuis636473_ennuis_
entwist1048803_entwist
eonism83213533_eonism
etatist7415033etatist
eternise8119663eternise
exist124618943_e_xist
feist86230073fe__ist
feminist131911333feminist
fennier10339253fennier
ferniest1132214153ferniest
ferninst11238323ferninst
feudist1137573feudist
finniest113011403finniest
funnest102912003funnest
funniest113010733funniest
genoise839423genoise
ginniest92610513ginniest
hedonist1249553hedonist
heist87030913he__ist
henbit111412003henbi_t
henbits12177003henbits
hennas94211803hennas_
hornist102314823hornist
hunnish1336163hunnish
hymnist1546633hymnist
insist6314513_insist
internist9414883internist
ironist7314843ironist
jennet134714953jenn_et
jennets14517633jennets
jennies143511623jennies
jinnis13489053jinnis_
keenest11410963keenest
kenning124010543kenning
leanest7415863leanest
leftist10279353leftist
legist71315253le_gist
lenis56326863le_nis_
lentisk1136063lentisk
lutenist8610663lute_nist
mannish121710693mannish
meanest9315703meanest
melanist10313053melanist
metrist9317063metrist
monist84324983_monist
neist54628443__neist
nunnish1035933nunnish
onanist7314633onanist
penis75129323pe_nis_
pennant9312493pennant
penni74617903penni__
pennia84412973penni_a
pennies94218813pennies
pennine93712953pennine
penning103616493penning
peonism11611103peonism
persist9315853persist
pianist9615103pianist
plenist9314333plenist
punniest102511583punniest
realist73225383realist
reenlist8410363reenlist
reknit10312533rekni_t
reknits1137073reknits
relist64628413re_list
renest64529713re_nest
renins64526453renins_
rennase738713rennase
rennet64624853renn_et
rennets75212633rennets
rennin63914033renni_n
rennins74013413rennins
resist64524533re_sist
retwist1039483retwist
revuist1038473revuist
runniest82911203runniest
sennas64214233sennas_
sennet64224143senn_et
sennets73712583sennets
sennight1245143sennight
sexist133013483se_xist
sternest8314433sternest
sunniest82712913sunniest
tachist12613293tachist
tangiest92915223tangiest
tanists7313653t_anists
tannic82811473tanni_c
tannin62613923tanni_n
tanning83618253tanning
tannins72813223tannins
tarnish101611873tarnish
tawniest11279343tawniest
teariest82417263teariest
techiest1359833techiest
teenier72611143teenier
teens56227483teen_s_
teensiest945833teensiest
teensy9478273teen_sy
teentsy1034073teentsy
teinds738263teinds_
teleost7410523teleost
telnet6518833teln_et
telnets738373telnets
tempest1139223tempest
tenail64516113tenai_l
tenails73713923tenails
tenant6322473te_nant
tenants7311013tenants_
tending94419163tending
tends65425583te_nds_
tendus75111183tendus_
tenebrist1145643tenebrist
tenet55542213te_n_et
tenets65518953tenets_
tenia55324483te_ni_a
teniae64517353te_niae
tenias64720073te_nias
tenner64117103tenn_er
tenners74014923tenners
tenoning938893tenoning
tenons62916603tenons_
tenorists948193tenorists
tenors63217753tenors_
tenpin8310583tenpi_n
tenpins9410073tenpins
tens45647413te_n_s_
tense55225843te_n_se
tenses64722553tenses_
tensile72612733tensile
tensing84616653tensing
tension7311803tension
tensity1039103tensity
tensive10269913tensive
tent46159863te_n__t
tenths94412663tenths_
tentie62521183tenti_e
tentier73815923tentier
tenting84621153tenting
tents56434213te_nts_
tenues63816443tenues_
tenuity1037453tenuity
terais64023513terais_
ternes65422903ternes_
ternion739493ternion
terns55226873tern_s_
territ63421373terri_t
territs72714503territs
tersest71713993tersest
test48651623te___st
testiest82715223testiest
testis64916713testis_
tetanise8610203tetanise
tetris62816293tetris_
theist9314763t_heist
theorist1149553theorist
thinnest11248893thinnest
thinnish1454873thinnish
tiniest73020123tiniest
tinnier72910143tinnier
tinnily1047363tinnily
tinning83117283tinning
titlist7312923titlist
toniest73218903toniest
tonish93415903t_onish
tonnes65320853tonnes_
tourist7313203tourist
townish13167933townish
transit7317163transit
trendiest1038423trendiest
tsarist7712253tsarist
tubaist938703tubaist
tubist83013163t_ubist
tundish1137283tundish
tunnies73614263tunnies
tunning83514453tunning
twiniest1147153twiniest
twist86820983t__wist
typist1139823t_ypist
tzarist1659103tzarist
veiniest1139383veiniest
venins93816703venins_
verist93823893ve_rist
wannest103915003wannest
weeniest112411213weeniest
wennier10318603wennier
yenning11369493yenning

Search took 8 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 Filter1786911340270.440406115.9
2DLD Change Limit1340272416.57620381.2
3Display Results2412410.0932591.4
 (SQL Overall)1786912417.10925135.9
 
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.