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

359 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
behaved1617668(None) 
behave14209011behave_
behaver15206721behaver
behaves15198521behaves
behoved16205561behoved
beaded104922422be_aded
beaked135919492be_aked
beamed115720732be_amed
beaned95621472be_aned
beaver114819252be_aver
begazed2036202begazed
behalves1644082behalves
behavers16205612behavers
beheaded1536372beheaded
behooved1743132behooved
behove14207202behove_
behoves15177352behoves
belaced124112152belaced
belated103520012belated
belayed133610082belayed
beloved13188392beloved
benamed122911092benamed
beraked144312432beraked
berated104422132berated
bereaved1446402bereaved
beshamed1635732beshamed
beslaved1435022beslaved
betaxed17307022betaxed
bewared13310112bewared
braved124817442b_raved
deaved114916552de_aved
eaved95924502_e_aved
heaved134717862he_aved
leaved105719022le_aved
reaved104523922re_aved
repaved133311132repaved
reshaved1536872reshaved
shaved135118382_shaved
sheaved143411632sheaved
weaved133913482we_aved
aerated85322373aerated
ashamed1336243ashamed
baaed85218163b__aaed
baked126130773b__aked
baled85436443b__aled
baned85436353b__aned
bared85144483b__ared
based85331583b__ased
bated85935533b__ated
bayed115423023b__ayed
beached154516553beached
bead75937923be_a__d
beader94623793be_ader
beaker125520693be_aker
beard86024963be_a_rd
bearded114212133bearded
bearer85323913be_arer
beaten84617063be_aten
beater84729393be_ater
beavered1437503be_avered
beavers124417323be_avers
becalmed1534813becalmed
became123213163became_
becapped1733933becapped
bechalked2143593bechalked
bechamel1754283bechamel
bechanced1945643bechanced
becharmed1944663becharmed
becked155417763be_cked
bedamned1434583bedamned
bedaubed1443183bedaubed
bedded115114063be_dded
bedewed1437153bedewed
bedraped1455813bedraped
beefed123510873be_efed
beehive1554033beehive_
beehives1644483beehives
beeped115313453be_eped
beetled1038213beetled
beeves114615043be_eves
begalled1236013begalled
begaze1838333begaze_
begazes1937963begazes
beggared1334753beggared
begged115013803be_gged
behalf14310953beha_lf
behaving1735453behaving
behavior1662203behavior
behead1239923beh_ead
beheader1436043beheader
beheld1236413beh_eld
behind1238063beh_ind
behold1247343beh_old
behoove1553773behoove_
behooves1653793behooves
behowled1733463behowled
beladied1236663beladied
belaud939133bela_ud
belauded1244793belauded
belayer12339503belayer
belched154011843belched
beleaped1336103beleaped
belied95022163be_lied
believed14427923believed
belive115415303belive_
belled94626183be_lled
bellied104314073bellied
beloveds14153963beloveds
belted94020633be_lted
bemeaned1335783bemeaned
bemired123410633bemired
bemixed19337053bemixed
bemoaned1335553bemoaned
bemused1236713bemused
bename103316073bename_
benames112814603benames
benched154713943benched
bendayed1534873bendayed
bended105521233be_nded
berake124216083berake_
berakes134815773berakes
berate84729023berate_
berates94126853berates
bereave1258353bereave_
bereaver1346673bereaver
bereaves1338263bereaves
berhymed1943313berhymed
berimed124912283berimed
bermed115217723be_rmed
berobed1238233berobed
berried103714043berried
berthed13259123berthed
beshame1447483beshame_
beshames1537203beshames
beshiver1634483beshiver
bested94922753be_sted
betake124512703betake_
betaken13438283betaken
betakes134212523betakes
bethanked1943283bethanked
betided114810203betided
betrayed1436303betrayed
betted94721163be_tted
bevel104517043be__vel
beveled133811123beveled
bewailed1435343bewailed
beware11313713beware_
bewares12313373bewares
bewrayed1733933bewrayed
biased94012223b_iased
bivalved1742683bivalved
bladed104717763b_laded
blamed116017953b_lamed
blared95018243b_lared
blawed124713893b_lawed
blazed184314713b_lazed
bleared104211253bleared
bleated104015973bleated
bloated104513433bloated
boated94221973b_oated
borated104116363borated
braced115420603b_raced
braked135318693b_raked
brave104925503b_rave_
braver114719043b_raver
braves115524083b_raves
bravoed13436113b_ravoed
brayed124615783b_rayed
brazed184717083b_razed
breaded115014063breaded
breamed124011593breamed
caved116227563__caved
ceased94920783ce_ased
cerated103922473cerated
chafed154813913_chafed
chared125423693_chared
chased125019293_chased
chawed155214603_chawed
cheated134416343cheated
cleaved134010483cleaved
craved125417773_craved
deaned84620453de_aned
deave95022333de_ave_
deaves105319533de_aves
debased113310583debased
debated113916083debated
decayed14309333decayed
defaced142910973defaced
defamed14309833defamed
delated93722873delated
delayed123310763delayed
deleaved1346573deleaved
delved114112753de_lved
depraved1535543depraved
derated93623503derated
derived123912763derived
dewaxed19316053dewaxed
eared65139503_e_ared
eased65430403_e_ased
eave75733583_e_ave_
eaves85231993_e_aves
elated74725823_elated
erased74816753_erased
evaded1137063_evaded
exhaled1835283exhaled
feared106320433fe_ared
feased105718713fe_ased
feazed195112633fe_azed
geared85317743ge_ared
gelated93615633gelated
graved114818813_graved
greaved12408913greaved
haded105227623__haded
haed86338583__ha_ed
haled95335823__haled
halved134813903__halved
hared95742183__hared
hated95734023__hated
have106137073__have_
haven114718533__haven
haver115124463__haver
haves116034873__haves
hawed126025423__hawed
hayed125822013__hayed
hazed185222203__hazed
headed114020473he_aded
healed105121443he_aled
heaped124516903he_aped
heated104525593he_ated
heave114521813he_ave_
heaven123912603he_aven
heaver124819673he_aver
heaves124120303he_aves
heehawed1842733heehawed
helved134313703he_lved
hived125217913__hived
inhaled1169333inhaled
jeaned143813463je_aned
jehad1637683jeha__d
laved95028593__laved
leaded84221543le_aded
leafed105713873le_afed
leaked114217703le_aked
leaned73422543le_aned
leaped94317773le_aped
leased74722883le_ased
leave84723723le_ave_
leaven95013073le_aven
leaver94321513le_aver
leaves94222383le_aves
legated92513983legated
meated94222403me_ated
medaled113411603medaled
melamed1249633melamed
menaced122710093menaced
metaled102913873metaled
misbehaved2152093misbehaved
neared75119803ne_ared
negated93413233negated
nerved104111683ne_rved
paved115525263__paved
peaced115818913pe_aced
peaked136117403pe_aked
pealed95322803pe_aled
peavey14398793pe_avey
pedaled113711873pedaled
peeved124112883pe_eved
petaled103614143petaled
phased124011973_phased
prepaved16177223prepaved
pshawed16103033pshawed
raved94931433__raved
reamed94326123re_amed
reaped94122453re_aped
reared75930013re_ared
reave84528023re_ave_
reaver94524733re_aver
reaves94127573re_aves
rebated103619693rebated
recaned102817203recaned
redated93120923redated
reeved104118713re_eved
refaced133713573refaced
regaled93615953regaled
regave104713383regave_
rehabbed1663713rehabbed
rehanged1357833rehanged
rehashed1536063rehashed
reheated122415003reheated
rehired115013153rehired
reived104518133re_ived
relaced103517213relaced
related83327573related
relaxed153312523relaxed
relayed113212753relayed
relived115114683relived
remated103522473remated
removed134611313removed
renamed103114523renamed
repave114813873repave_
repaves123513653repaves
resawed113111183resawed
reshaped1437203reshaped
reshave1338603reshave_
reshaven1435193reshaven
reshaves1438733reshaves
retaped103814283retaped
retaxed153512233retaxed
revived144211653revived
revved13469723re_vved
rewaked153811903rewaked
rewaxed18409343rewaxed
reweaved1535953reweaved
saved95127113__saved
seabed95017693se_abed
sealed74328363se_aled
seamed94823883se_amed
seared75232843se_ared
seated75131053se_ated
sedated93714343sedated
sepaled10510593sepaled
served104616813se_rved
shaded114518873_shaded
shaled105023953_shaled
shamed125120213_shamed
shaped125020103_shaped
shared105829063_shared
shave114425893_shave_
shaven124213303_shaven
shaver123718913_shaver
shaves125224933_shaves
shawed134817233_shawed
sheafed14388973sheafed
sheared114516003sheared
sheave124514003sheave_
sheaves134412973sheaves
shelved14379933shelved
shoved134214273_shoved
slaved104017043_slaved
sleaved113611133sleaved
staved103918053_staved
teamed95418593te_amed
teared75722153te_ared
teased74721153te_ased
teated74924023te_ated
thawed13458463_thawed
unhalved1556513unhalved
unpaved133410053unpaved
unsaved113312193unsaved
unshaved15157733unshaved
upheaved1733763upheaved
vealed103916323ve_aled
waved125223583__waved
weaned103816153we_aned
weave115218533we_ave_
weaver123916613we_aver
weaves123616373we_aves
whaled134612033_whaled
yeaned103813903ye_aned

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.1561145455.1
2DLD Change Limit1340273597.86017051.8
3Display Results3593590.1262849.2
 (SQL Overall)1786913598.14221946.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.