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

341 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
tempeh1335746(None) 
temped113912891temped
tempehs14325151tempehs
temper103914091temper
hempen1338962hempen
tamped114317042tamped
tamper104618512tamper
teepee8314362teepee
temp85323332temp__
tempera11329042tempera
tempers113513012tempers
tempest1139222tempest
tempi94912202temp_i
temple102811332temple
templed12278552templed
temples112610892temples
templet112712002templet
tempo95214972temp_o
tempos103812292tempos
temps95417132temp_s
tempt95124842temp_t
tempted12317282tempted
tempter11358212tempter
tempts10439452tempts
tepee74724212te_pee
tumped114216232tumped
almeh106214553alm_eh
amped104820513_amped
attemper12103633attemper
beeped115313453beeped
beeper103714093beeper
bumped134414003bumped
bumper123714343bumper
bumph144911983bump_h
camped134720233camped
camper124722213camper
cepe84926653ce_pe_
cepes94424463ce_pes
comped135919873comped
compel124412893compel
damped124315583damped
dampen114310593dampen
damper114117753damper
deepen9339193deepen
deeper93613503deeper
deme76536283dem_e_
demes86032693dem_es
demies94825803demies
demoed103713443demoed
depth114311853de_pth
dumped123814493dumped
dumper114615213dumper
embed105014303_embed
ember95516803_ember
emcee9315943_emcee
eme55837183_em_e_
emeer74815363_emeer
emes65434663_em_es
emeu66723433_em_eu
emmer94314463_emmer
emmet94221383_emmet
empery1348683_empery
empty1247763_empty
epee64628503_e_pee
etape74413703etape_
etapes85415293etapes
expel1448233_expel
feme96130543fem_e_
femes105626223fem_es
femme125011433femme_
femmes135410213femmes
gemmed12329573gemmed
gimped123911473gimped
hamper134518653hamper
heaped124516903heaped
heaper114119523heaper
helped124714153helped
helper114313093helper
heme95034413hem_e_
hemes105031083hem_es
hemmed144211463hemmed
hemmer134112643hemmer
hemp115725623hemp__
hempie132410563hempie
hempier14319003hempier
hemps126917333hemp_s
hempy154912763hemp_y
hepper133412663hepper
herpes115517323herpes
humped144015243humped
humper134115883humper
humph155712213hump_h
imped105117983_imped
impel95711773_impel
itemed936603item_ed
jeeped16469843jeeped
jimper17389863jimper
jumped183511553jumped
jumper173612373jumper
keeper123811913keeper
kelped13449543kelped
kemp126418763kemp__
kemps135012523kemp_s
kempt134318463kemp_t
kepped15309533kepped
keppen14346563keppen
lamped114017543lamped
leaped94317773leaped
leaper88118943leaper
leper74820743le_per
limped114817123limped
limper104117853limper
limpet103518633limpet
lumped114216963lumped
lumpen104010663lumpen
lumper103816653lumper
lymph1547043lymp_h
member12258853member
meme85330553mem_e_
memes94927703mem_es
mumped133813163mumped
mumper123513523mumper
nymph1555213nymp_h
oompah1334253oompah
oomph1236973oomp_h
pamper124316663pamper
peeped113915383peeped
peeper103614803peeper
peh86740963___peh
pepped103113393pepped
pepper93512943pepper
pimped134913483pimped
pumped133915563pumped
pumper124415553pumper
ramped114617903ramped
reaped94122453reaped
reaper84223143reaper
remeet86325473remeet
remet74843723rem_et
remex146315793rem_ex
reopen8311573reopen
repeg84015053re_peg
repel74921403re_pel
repped114616723repped
retemper1235183retemper
romped114513653romped
romper104213683romper
seeped94317523seeped
seme65836653sem_e_
semen75724103sem_en
semes75731583sem_es
semple103212753semple
sempre102710093sempre
simper103616293simper
stamped124812813stamped
stamper113714403stamper
steeped103412283steeped
steepen9348653steepen
steeper93812773steeper
stemmed12278153stemmed
stemmer113210183stemmer
steppe10319873steppe_
stepped123210053stepped
stepper113010853stepper
steppes113110693steppes
stomped124110533stomped
stomper114111233stomper
stumped124210153stumped
stumper113610093stumper
tame66343663tam_e_
tamed85528513tam_ed
tamer75230103tam_er
tames75242013tam_es
tamp86133003tamp__
tampan102512323tampan
tampers113516743tampers
tampon102911233tampon
tamps95524083tamp_s
tape64538143t_ape_
taped85327423t_aped
taper74829773t_aper
tapes75838603t_apes
tapped113820053tapped
tapper104419613tapper
tappet103820113tappet
taupe7314163taupe_
taupes8212673taupes
teach105221123te_ach
teamed95418593teamed
teapot8416763teapot
teapoy1138113teapoy
teared75722153teared
tearer64822903tearer
tease55428713tease_
teased74721153teased
teasel63914983teasel
teaser65421523teaser
teases65426273teases
teated74924023teated
teazel15368543teazel
tech95925443te__ch
teched124014433teched
tedded93810893tedded
tedder83312153tedder
tee38366873te__e_
teed55439263te__ed
teel46335803te__el
teem66132603te__em
teemed95114873teemed
teemer85515743teemer
teen45938203te__en
teener64717503teener
teepees939263teepees
tees45353583te__es
teeter65420313teeter
teeth87315853te_eth
teethe94511313teethe
tegmen988403tegmen
telae54323293telae_
tele45040873te_le_
teles54536003te_les
telex125214823te_lex
telfer9379893telfer
teller63519813teller
telnet6518833telnet
telpher1235563telpher
temperas12278233temperas
tempered13248213tempered
temperer12227723temperer
tempests1234443tempests
temping122710693temping
templar1145643templar
templets12226143templets
tempters12257293tempters
tempura11295253tempura
tench105620003te_nch
tended83819483tended
tender74121843tender
tenet55542213te_net
tenge65720433tenge_
tenner64117103tenner
tenpin8310583tenpin
tenrec837513tenrec
tense55225843tense_
tensed74817833tensed
tenser64919433tenser
tenses64722553tenses
tented74221003tented
tenter64623933tenter
tenth85421833te_nth
tenues63816443tenues
teopan839353teopan
tepa66021683te_p_a
tepal76319583te_pal
tepas76521683te_pas
tepees84215243tepees
tepefy1434803te_pefy
tepid8314313te_pid
tepoy10312163te_poy
teraph11319093teraph
terce75721843terce_
tercel83612993tercel
terces83921413terces
tercet83624913tercet
termed94816703termed
termer85717253termer
terne56426153terne_
ternes65422903ternes
terpene92310853terpene
terret63425623terret
terse55026823terse_
terser67317823terser
tested74421523tested
testee64323303testee
tester64227153tester
testes65125823testes
teth76327893te__th
tether93716103tether
tetter64322453tetter
teuch105214853te_uch
teugh95511613te_ugh
tewed94718533te_wed
theme105921733them_e_
themed125912583them_ed
themes115319253them_es
thumped15387413thumped
thumper14356953thumper
timber104012683timber
time66235013tim_e_
timed85223613tim_ed
timer75626043tim_er
times75630823tim_es
tipped114418263tipped
tipper103918413tipper
tippet103917873tippet
tmeses85712243tmeses
tombed113812133tombed
tome67543193tom_e_
tomes76037383tom_es
tommed113310143tommed
tope65946383t_ope_
toped85631313t_oped
topee76029953t_opee
toper75231023t_oper
topes76941763t_opes
toph96326873t_op_h
tophe106718973t_ophe
topped114617723topped
topper103817603topper
toupee8316133toupee
tramped124312433tramped
tramper113812163tramper
trapes85024463trapes
tripe75425383tripe_
tripes85324873tripes
trompe105611263trompe_
tromped124210293tromped
trompes114111623trompes
trope75725803trope_
tropes84824353tropes
trumped12439713trumped
trumpet113810723trumpet
tump85927033tump__
tumps95420793tump_s
tupped114013233tupped
turpeth1284813turpeth
tusseh9448423tusseh
tympan13257013tympan
type96223743t_ype_
typed115815453t_yped
types105721063t_ypes
typey135511883t_ypey
umped104717273_umped
vamped144211013vamped
vamper134212653vamper
veepee11311483veepee
vesper1138083vesper
weeper114313303weeper
wimped144211513wimped
yelped12439363yelped
yelper11458783yelper

Search took 7 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.1401276364.3
2DLD Change Limit1127163416.00018786.0
3Display Results3413410.0933666.7
 (SQL Overall)1786913416.23328668.5
 
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.