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

229 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
behavers1620561(None) 
beavers124417321be_avers
behaver15206721behaver_
behaves15198521behave_s
beaders104120182be_aders
beakers134216872be_akers
bearers94619592be_arers
beaters94925042be_aters
beaver114819252be_aver_
behalves1644082behalve_s
behave14209012behave__
behaved16176682behave_d
behaviors1772042behaviors
beheaders1545152beheaders
behoves15177352behove_s
bejabers1933632bejabers
belayers13298142belayers
bereavers1446122bereavers
beshivers1743712beshivers
bravers124715522b_ravers
havers124721482__havers
heavers133717192he_avers
leavers103717782le_avers
reavers108320742re_avers
shavers134115092_shavers
weavers133714462we_avers
avers85127313___avers
bahadurs1442553bahadurs
bakers125323453b__akers
balers85626933b__alers
beader94623793be_ader_
beaker125520693be_aker_
beanery1237563be_anery
bearer85323913be_arer_
bears75739043be_a__rs
beater84729393be_ater_
beavered1437503be_avered
bechamels1853033bechamels
bedcovers1783563bedcovers
bedders113513383be_dders
bediapers1444333bediapers
bedmakers1844383bedmakers
beehives1644483beehive_s
beepers113612383be_epers
beers75628393be___ers
beetlers1037393beetlers
beeves114615043be_eve_s
beezers18349243be_ezers
begazes1937963begaze_s
behaving1735453behaving
behavior1662203behavior
behaviours1871283behaviours
beheader1436043beheader_
beholders1544933beholders
behooves1653793behoove_s
behove14207203behove__
behoved16205563behove_d
bejabbers1971953bejabbers
belabors1236403belabors
belayer12339503belayer_
belchers153510023belchers
beliers94617383be_liers
believers14346633believers
beloveds14153963beloveds
belters93819413be_lters
benames112814603bename_s
benchers153611013benchers
benders104021063be_nders
berakes134815773berake_s
berates94126873berate_s
bereaver1346673bereaver_
bereaves1338273bereave_s
beshames1537203beshame_s
beshiver1634483beshiver_
betakes134212523betake_s
betatters1134963betatters
betrayers1445013betrayers
betters94422093be_tters
bevelers13389453bevelers
bevels113913983be__vels
bevors111610343be__vors
bewailers1434233bewailers
bewares12313373beware_s
bewrayers1743483bewrayers
bilayers13296923bilayers
bladers104214683b_laders
blamers115314213b_lamers
blazers184811683b_lazers
bleaters103412323bleaters
bloaters103311023bloaters
boaters93419243b_oaters
bracers114616703b_racers
braver114719043b_raver_
bravery15428133b_ravery
braves115524083b_rave_s
brayers124511903b_rayers
brazers184513943b_razers
breakers143810973breakers
cadavers1435883cadavers
cavers115026843__cavers
chafers154512743_chafers
chasers123714923_chasers
chawers154412053_chawers
cheaters133613513cheaters
clavers124314903_clavers
cleavers13398873cleavers
cravers124416553_cravers
dealers84118613de_alers
deaves105319533de_ave_s
debasers11377903debasers
debaters113511923debaters
decayers14307963decayers
defacers14237993defacers
defamers14258523defamers
delayers12268663delayers
delivers123310753delivers
delvers113411993de_lvers
depravers1534683depravers
derivers123811363derivers
dewaters122910723dewaters
eagers74523683_e_agers
eaters65535953_e_aters
eaves85231993_e_ave_s
elaters74420193_elaters
elvers93814983_e_lvers
erasers74413943_erasers
evaders1136933_evaders
fearers104815273fe_arers
fevers125414893fe__vers
gravers114515273_gravers
halers94926913__halers
halvers133311423__halvers
haters94930403__haters
havens124514043__havens
haver115124463__haver_
haves116034873__have_s
hayers124415943__hayers
hazers184615953__hazers
headers113819393he_aders
healers104319463he_alers
heapers123616673he_apers
hearers104319783he_arers
heaters104225223he_aters
heavens13439303he_avens
heaver124819673he_aver_
heaves124120303he_ave_s
hovers124320253__hovers
inhalers1166643inhalers
lavers94526363__lavers
leaders83819603le_aders
leakers113415423le_akers
leaners73718173le_aners
leapers93716663le_apers
leasers74717843le_asers
leavens10409303le_avens
leaver94321513le_aver_
leaves94222383le_ave_s
levers94621323le__vers
meaners94415243me_aners
menacers12279313menacers
metamers1249623metamers
misavers1348063misavers
misbehavers2151863misbehavers
negaters9349783negaters
newwavers1841873newwavers
palavers1337993palavers
pavers115021823__pavers
peaveys15324063pe_aveys
pedalers11239393pedalers
preavers13910263preavers
quavers19309013_quavers
ravers94628183__ravers
readers83823773re_aders
reamers94221083re_amers
reapers93520453re_apers
rearers74323563re_arers
reaver94524733re_aver_
reaves94127573re_ave_s
rebaters103413943rebaters
recovers133511123recovers
regalers94311133regalers
rehabbers1683133rehabbers
rehammers1644503rehammers
reheaters122010273reheaters
reivers105117083re_ivers
relaters83218153relaters
relaxers15298263relaxers
remakers143811303remakers
removers13449223removers
repapers1258833repapers
repaves123513653repave_s
reshapers1435493reshapers
reshaves1438733reshave_s
retakers123511133retakers
revers94529633re__vers
revivers14389633revivers
savers93825923__savers
sealers74323553se_alers
seamers94719433se_amers
seaters74028943se_aters
servers103214833se_rvers
severs94121123se__vers
shaders115915553_shaders
shakers144015563_shakers
shapers124016893_shapers
sharers104720623_sharers
shaver123718913_shaver_
shaves125224933_shave_s
shearers113911323shearers
sheaves134412973sheave_s
shelvers14388813shelvers
shivers133714833_shivers
shovers134613003_shovers
slavers103716503_slavers
tearers75218233te_arers
teasers75317243te_asers
thalers106212263_thalers
thawers13428483_thawers
theaters114211903theaters
upheavers1742593upheavers
vealers103214293ve_alers
vetivers1435163vetivers
wavers125022473__wavers
weaners104613833we_aners
wearers104615903we_arers
weaver123916613we_aver_
weaves123616373we_ave_s
weevers13379993we_evers
whalers13529703_whalers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622296.90621164.5
3Display Results2292290.0932462.4
 (SQL Overall)1786912297.15524974.3
 
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.