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

285 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
behests123595(None) 
behest11314611behest_
beasts84519722be_asts
beets76131442be_e_ts
begets96215522bege_ts
beheads1338522beheads
bejesus1643692bejesus
bemists113410702bemists
bequests1944112bequests
berets85822522bere_ts
besets85718802bese_ts
bests75932612b__ests
bheesty1542492bheesty
chests114916262_chests
detests83711742detests
devests114410472devests
egests74411252_egests
geests75912162ge_ests
hests85829932__hests
reests64618892re_ests
reheats104513522reheats
renests74014212renests
retests73813852retests
revests104413732revests
apheses12610703apheses
aphesis12610513aphesis
arbelests1143653arbelests
arrests73312683arrests
atheists1138713atheists
attests7278813attests
bahts105617803bah__ts
barest85327693barest_
barghests1543313barghests
basest84720493basest_
bassets96414823bassets
basts75936933b__asts
beast76338643be_ast_
beats76042243b__eats
beauts86015283be_auts
beckets15399823beckets
becrusts1244843becrusts
bedecks1635793bedecks
bedells10379363bedells
bedels94015273bede_ls
bedews12398943bede_ws
bedless1039703bedles_s
bedposts1343873bedposts
bedsheets1542943bedsheets
bedsits1037563bedsits
beefs105618563be_e_fs
beeps95320973be_e_ps
beers75628393be_e_rs
bees65453383be_e__s
beet66457543be_e_t_
beeves114615043be_eves
befits114711503be_fits
befrets1237613befrets
beget85632563bege_t_
behaves15198523behaves
behead1239923behe_ad
beheld1236413behe_ld
behemoth1842223behemoth
behemoths1951773behemoths
behinds1335283behinds
beholds1336423beholds
behoves15177353behoves
behowls1534443behowls
bekiss1236373bekis_s
beknots1335083beknots
beleaps1138053beleaps
belts75931163b__elts
bemeans1148743bemeans
bemist105216963bemist_
bemuses1139293bemuses
beneath1236973beneath
benefits1345713benefits
benes75536233bene__s
bennets94712163bennets
bents76033693b__ents
bequest1837823bequest_
bereft114317303bereft_
beret74946363bere_t_
beretta938463beretta
berettas1046733berettas
beseems1175913beseems
beses75830723b__eses
beset76739133bese_t_
beshouts1346763beshouts
besmuts1134683besmuts
besots86415453be_sots
best66355323b__est_
betels84515063bete_ls
bethels1238533bethe_ls
bethesda1441953bethesda
bethesdas1541763bethesdas
betises94816123betises
bets67051443b__e_ts
bevels113913983beve_ls
beweeps1494563beweeps
bewept13410323bewept_
bezants1877343bezants
bezels173712283beze_ls
bheestie1343153bheestie
bheesties1443923bheesties
bhoots11459913b_hoots
bhuts105812953b_h_uts
bidets95215533bide_ts
bisects1137133bisects
blasts85116773b_lasts
bleats85518613b_leats
bless75917813b_les_s
blest76431723b_lest_
blets75324943b_le_ts
bluest84016483bluest_
bluets87215493blue_ts
boasts85017923b_oasts
boheas114013213bohe_as
bonesets1036843bonesets
boosts86115013b_oosts
breasts939703breasts
brents84717273b_rents
brevets12519393breve_ts
burets84321263bure_ts
bursts85116243b_ursts
busts75227693b__usts
celesta947643celesta
celestas1057083celestas
celeste949653celeste
celestes10310013celestes
cements112714223cements
cheats114519543_cheats
cheeses123613103cheeses
cherts115617233_cherts
chess105016923_ches_s
chest104926143_chest_
chesty144610503_chesty
cohosts12398813cohosts
crests85218703_crests
deceits102810883deceits
deets65330243de_e_ts
defeats113511233defeats
defects134511523defects
degusts936063degusts
dehorts11379773dehorts
deists74916433de_ists
dejects17389223dejects
delists84414173delists
demasts1089223demasts
dements103016623dements
deserts82513053deserts
desists83611723desists
detects104011093detects
detents83615153detents
detest74122843detest_
devest104418703devest_
digests93610613digests
divests114510933divests
easts57530323_e_asts
ebbets10376833ebbe_ts
ecesis84611203_ecesis
egest65222343_egest_
egesta7428653_egesta
ejects15409953_ejects
elects83315003_elects
emeses86114963_emeses
emesis84712623_emesis
erects84116183_erects
events94814073_events
everts94514893_everts
exerts133712293_exerts
exists134710913_exists
feasts95116093fe_asts
feists94915313fe_ists
fests85828043__fests
fewest12311663fewest_
feyest12311403feyest_
forests104114953forests
geest64829623ge_est_
geneses82613523geneses
genesis82510823genesis
genets75716663gene_ts
gerents82612923gerents
gests66028813__gests
ghosts10489273_ghosts
guests74311203_guests
heats85838403__heats
hefts116218153__hefts
heists96814633he_ists
hents87330743__hents
hest75950773__hest_
hets75547203__he_ts
hists86328373__hists
hosts85526703__hosts
incests92711383incests
infests10279793infests
ingests83210983ingests
invests10319683invests
jests125922453__jests
keets95123483ke_e_ts
keysets1434343keysets
khets124913433_khe_ts
latests73910313latests
leasts64616413le_asts
leets54927123le_e_ts
legists899593legists
meets74224613me_e_ts
merest84725113merest_
molests93311563molests
nemeses948663nemeses
nemesis937373nemesis
nests55728003__nests
newest9314213newest_
obtests9136233obtests
pests75933273__pests
preheats1339413preheats
prests84021263_prests
pretests10310013pretests
priests93810863priests
quests153310353_quests
recasts93413533recasts
recepts113010263recepts
recess8314263reces_s
recheats1339193recheats
reest54938093re_est_
refects124012743refects
regents83416543regents
rehears103312773rehears
reheat94423943reheat_
reheels10298253reheels
rehems113410983rehe_ms
rejects163910693rejects
relents74018503relents
relets64025673rele_ts
relists73817053relists
remeets93712413remeets
remelts93511493remelts
renest64529713renest_
repasts93611933repasts
repeats94316053repeats
repents93717623repents
requests1735743requests
rerents73319423rerents
reseats74319583reseats
resects94115593resects
resents74221223resents
resets65427613rese_ts
resists74414923resists
rests54935873__rests
retest64028453retest_
reverts104715043reverts
revest94623603revest_
revets94022173reve_ts
rewets94617213rewe_ts
rhesus936203_rhesus
schists1248543schists
selects91912143selects
serest64831613serest_
sexists14267673sexists
sheets93918503_sheets
shists96515113_shists
teleosts846423teleosts
teleses7313123teleses
telesis7310793telesis
tempests1234443tempests
tenets65518953tene_ts
tests56530193__tests
thefts12387923_thefts
theists1039153theists
theses96517973_theses
thesis94913733_thesis
thesps11448263_thesps
unrests7229463unrests
verists103613673verists
versets103913103versets
versts93914733ve_rsts
vests85325983__vests
weest85026773we_est_
weets85427723we_e_ts
wests85727003__wests
wheats125013223_wheats
whets115019613_whe_ts
whists124613813_whists
wrests95313083_wrests
yeasts96413053ye_asts
zests145419743__zests

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.406440125.6
2DLD Change Limit1340272856.67020094.0
3Display Results2852850.0933064.5
 (SQL Overall)1786912857.16924925.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.