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

259 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
tempest113922(None) 
tempests1234441tempests
dampest12411042dampest
deepest10310442deepest
hempiest1539022hempiest
heppest14228142heppest
jimpest18297552jimpest
limpest113712312limpest
steepest1038122steepest
tamest85721292tam_est
temped113912892tempe_d
tempeh13357462tempe_h
tempehs14325152tempehs
temper103914092tempe_r
tempera11329042tempera
tempers113513012tempers
tempested1444032tempested
temples112610892temples_
templet112712002templet
templets12226142templets
tempos103812292tempos_
temps95417132temp_s_
tempt95124842temp__t
tempts10439452tempts_
tensest72713312tensest
tersest71713992tersest
aeriest73924053aeriest
amplest11312333_amplest
anapest9311553anapest
armrest9310163armrest
beamiest123212763beamiest
bedpost1247243bedpost
behest11314613be_hest
bemist105216953bem_ist
bequest1837823bequest
bummest13298623bummest
bumpiest1437873bumpiest
campiest142212133campiest
cement103321663cem_ent
cepes94424463ce_pes_
cheapest1536073cheapest
compost134515353compost
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
deffest14308803deffest
deftest112611713deftest
demast9517063dem_ast
dement93825143dem_ent
demes86032693dem_es_
demies94825803demies_
demurest1137453demurest
densest83112473densest
detest74122843de_test
devest104418703de_vest
dewiest11312343dewiest
dimmest1249253dimmest
dumbest1238743dumbest
dumpiest1338743dumpiest
eeliest73516473eeliest
eeriest73620673eeriest
egest65222343_e_gest
eldest72912683_eldest
elmiest9310743elmiest
emes65434663_em_es_
emmet94221383_emme_t
emmets10349153_emmets
empery1348683_empery
empress1138163_empress
emptiest1278103_emptiest
etapes85415293etapes_
expect1758903_expect
expert15515353_expert
featest102715113featest
fellest10313753fellest
femes105626223fem_es_
femmes135410213femmes_
fewest12311663fe_west
feyest12311403fe_yest
fumiest12312193fumiest
gamest94919923gam_est
gamiest102816223gamiest
geest64829613ge__est
gemmiest13227623gemmiest
germiest11249913germiest
gimpiest1338473gimpiest
hemes105031083hem_es_
hempen1338963hempe_n
hemps126917333hemp_s_
herpes115517323herpes_
hippest14219753hippest
homiest124116633homiest
humpiest1538963humpiest
impost103011783_impost
imprest11310203_imprest
jumpiest1936863jumpiest
keenest11410963keenest
kemps135012523kemp_s_
kempt134318463kemp__t
lamest84722763lam_est
leanest7415863leanest
leftest10269463leftest
lewdest1136283lewdest
limiest93716103limiest
limpet103518633limpe_t
limpets11329783limpets
lumpiest1239253lumpiest
meanest9315703meanest
meekest1336893meekest
memes94927703mem_es_
merest84725113me_rest
nearest73415843nearest
neatest72516003neatest
newest9314213ne_west
numbest1138793numbest
peppiest11278563peppiest
perpent112318813perpent
pertest9317043pertest
pest65555293___pest
plumpest14236353plumpest
realest73322433realest
reddest9311953reddest
reest54938093re__est
remeet86325473rem_eet
remeets93712413remeets
remelt85123123rem_elt
remet74843723rem_e_t
remotest103310723remotest
renest64529713re_nest
repast83520633re_past
repeat85127213re_peat
repent84728873re_pent
request16311023request
respect11412033respect
respelt9312143respelt
retest64028453re_test
revest94623603re_vest
rimiest93215853rimiest
ripest84317943_ripest
rummest11279833rummest
seamiest102715413seamiest
searest73322023searest
seepiest102412623seepiest
semes75731583sem_es_
serest64831613se_rest
serpent92916283serpent
sexiest142112223sexiest
simplest122310223simplest
steamiest1138403steamiest
stemless1036653stemless
stemmiest1335143stemmiest
steppes113110693steppes_
sternest8314433sternest
stumpiest1335853stumpiest
tallest7317093tallest
tames75242013tam_es_
tamped114317043tampe_d
tamper104618513tampe_r
tampers113516743tampers
tamps95524083tamp_s_
tannest72617853tannest
tapes75838603t_apes_
tappet103820113tappe_t
tappets113610013tappets
tartest72517533tartest
taupes8212673taupes_
tautest72612443tautest
teapot8416763teap_ot
teapots939053teapots
teariest82417263teariest
teases65426273teases_
techiest1359833techiest
teeniest82112413teeniest
teepee8314363teepe_e
teepees939263teepees
tees45353583te__es_
teleost7410523teleost
teles54536003te_les_
telnet6518833telne_t
telnets738373telnets
temp85323333temp___
temperas12278233temperas
temperate1348513temperate
tempered13248223tempered
temperer12227723temperer
tempesting1544453tempesting
tempi94912203temp__i
temping122710693temping
templar1145643templar
template1238433template
temple102811333temp_le
templed12278563templed
tempo95214973temp__o
tempted12317283tempted
tempter11358213tempter
tempters12257293tempters
temptress1343133temptress
tempura11295253tempura
tenet55542213te_ne_t
tenets65518953te_nets
tennist72813113tennist
tenses64722553tenses_
tentiest82115613tentiest
tenues63816443tenues_
tepas76521683te_pas_
tepee74724213te_pe_e
tepees84215243te_pees
tepefy1434803te_pefy
terces83921413terces_
tercet83624913terce_t
tercets93512443tercets
termless1036233termless
ternes65422903ternes_
terpene92310863terpene
terret63425623terre_t
terrets72913583terrets
test48651623t___est
testes65125823testes_
testiest82715223testiest
themes115319253them_es_
thewiest14196343thewiest
thymiest1634733thymiest
tidiest83514873tidiest
times75630823tim_es_
timidest1136933timidest
tiniest73020123tiniest
tippet103917873tippe_t
tippets11339373tippets
tippiest122310013tippiest
tmeses85712243tmeses_
tomes76037383tom_es_
toniest73218903toniest
topes76941763t_opes_
topmast1138123topmast
topmost1148173topmost
trampiest13227893trampiest
trapes85024463trapes_
trapnest10310923trapnest
trimmest12227023trimmest
tripes85324873tripes_
tritest7315273tritest
trompes114111623trompes_
tropes84824353tropes_
truest64816193t_ruest
trumpet113810723trumpe_t
trumpets12315573trumpets
tumped114216233tumpe_d
tumps95420793tump_s_
types105721063t_ypes_
typeset1267743t_ypeset
typiest1238203typiest
typist1139823t_ypist
vampiest15237643vampiest
veriest103719133veriest
weakest1439003weakest
weepiest13219473weepiest
weest85026773we__est
wettest10239363wettest
wimpiest1538763wimpiest

Search took 9 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.470380193.6
2DLD Change Limit1340272597.46617951.6
3Display Results2592590.1102354.5
 (SQL Overall)1786912598.04622208.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.