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

222 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
bestuds1032675(None) 
bestud9439301bestud_
belauds1036642belauds
besmuts1134682besmuts
besteads11307122besteads
bested94922762bested_
bestirs9311132bestirs
bestows1248862bestows
bests75932612best__s
cestus84412912cestu_s
restudy1144762restudy
studs64415872__studs
testudo843362testudo
testudos943052testudos
asbestus1042953asbestu_s
basques18248673basques
bastards113310313bastards
basted95227233basted_
basters94930303basters
bastes85330383bast_es
basts75936933bast__s
battues94610193battues
bauds85821043b__auds
beads85429503be__ads
beards94116673be_ards
beasties102514653beasties
beasts84519723beast__s
beaters94925043beaters
beats76042243beat__s
beaus75127113be_au_s
beauts86015283be_auts
beclouds1345373beclouds
bedaubs1233693bedaubs
bedbugs13193503bedbugs
bedrugs11194283bedrugs
beds75937783be___ds
bedstands1343503bedstands
bedsteads1352693bedsteads
beetles9312083beetles
beets76131443beet__s
befouls1236053befouls
begirds1134883begirds
beglads11127263beglads
begums11429493be_gums
beheads1338523beheads
behinds1335283behinds
beholds1336423beholds
belaud939133belaud_
belted94020633belted_
belters93819413belters
belts75931163belt__s
bends85628973be__nds
benthos1238373benthos
bentos86218303bent_os
bents76033693bent__s
bermudas1342973bermudas
berthas12398763berthas
berths114712423bert_hs
bescours1245093bescours
beseems1175913beseems
beses75830723bes__es
besets85718803bes_ets
beshouts1346763beshouts
beshrouds1543063beshrouds
beside95114613bes_ide
besides104814533besides
besmudge1442283besmudge
besmudges1542413besmudges
besmut10310653besmu_t
besnows1245153besnows
besoms105712733bes_oms
besots86415453bes_ots
best66355323best___
bestead10389123bestead
bestial9311643bestial
besting104923923besting
bestir8311163best_ir
bestow1149463best_ow
bestrew1248003bestrew
bestrews1335603bestrews
bestrid1039973bestrid
bestride1138613bestride
bestrides1237913bestrides
bestrode1147143bestrode
bestrow1237253bestrow
bestrows1337043bestrows
bestudded1442543bestudded
betas75528763be_t_as
betels84515063be_tels
beths105519223be_t_hs
betide95115973be_tide
betides104915263be_tides
betons84919553be_tons
bets67051443be_t__s
bettas84913923be_ttas
betted94721163betted_
betters94422093betters
bettors93312473bettors
beyonds1335063beyonds
bilsteds1134273bilsteds
bisques18236893bisques
bisters93922613bisters
bistres94017213bistres
bistros92810983bistros
bosques18217973bosques
bostons9312903bostons
bosuns8439383bos_uns
buds75235173b___uds
bustards11308513bustards
busted95123153busted_
busters94724133busters
bustics11810883bustics
bustles93816323bustles
busts75227693bust__s
bututs8409423b_ututs
byssus1133763byssu_s
caestus947773caestu_s
centums11398783centums
cesiums1136303cesiums
cestas85018543cest_as
cestode1037963cestode
cestodes1138203cestodes
cestoids11308273cestoids
cestos84718093cest_os
cestuses1038083cestuses
cistus84611343cistu_s
desands94810163desands
desmids1166603desmids
disbuds11125243disbuds
dustups1033913dustups
escudo943373_escudo
escudos1043493_escudos
esters64627733_esters
estops84011223_estops
estrums9208603_estrums
estrus61912113_estrus
etude63612303_e_tude
etudes73811603_e_tudes
etuis54013133_e_tuis
fescues1236783fescues
festers104121393festers
fests85828043fest__s
fetus85816543fe_tu_s
feuds95914883fe__uds
gestes75721393gest_es
gests66028813gest__s
gesture839243gesture
gestures9310013gestures
getups9346853ge_tups
heptads1335873heptads
hests85829933hest__s
jested144416503jested_
jesters144118193jesters
jests125922453jest__s
letups8317683le_tups
leuds66214813le__uds
meatus85112923meatu_s
mestees94617753mestees
nested74720063nested_
nesters74422793nesters
nestles73015463nestles
nestors73614973nestors
nests55728003nest__s
oersteds934373oersteds
oestrums10156473oestrums
oestrus7169583oestrus
pentads1039523pentads
peptids12239323peptids
pesters93827093pesters
pestles93217693pestles
pestos84719083pest_os
pests75933273pest__s
pseuds944793_pseuds
rectums11338523rectums
rectus83314633rectu_s
redbuds11144283redbuds
rescues9312753rescues
reseeds84012333reseeds
resends83513713resends
resids74219153res_ids
resods74116303res_ods
resounds956483resounds
rested74430783rested_
resters74130403resters
rests54935873rest__s
restudies10156033restudies
restuff1346953restuff
restuffs1444193restuffs
scuds85116243__scuds
septums1135743septums
sestets7911473sestets
setups83910463se_tups
spuds85113673__spuds
stubs75016073__stubs
stud56220093__stud_
study94411793__study
stums75320083__stums
stuns54719493__stuns
suds56135293__s_uds
tectums11306423tectums
tested74421523tested_
testees74215913testees
testers74124543testers
testes65125823test_es
testis64916713test_is
testons7313563testons
tests56530193test__s
vertus94613603vertu_s
vespids1334613vespids
vestals104612333vestals
vestas95916683vest_as
vested104217353vested_
vestees103513173vestees
vests85325983vest__s
vesture10310373vesture
vestures11311043vestures
westers105221963westers
wests85727003west__s
xystus16354423xystu_s
zested164214043zested_
zesters163517293zesters
zests145419743zest__s

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272226.33021173.3
3Display Results2222220.0902466.7
 (SQL Overall)1786912226.84326113.0
 
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.