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

287 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
beebees113801(None) 
beebee10313061beebee_
baubees11348712baubees
bawbees14337242bawbees
beeches143413882beeches
beedies10314202beedies
beepers113612382beepers
beetles9312082beetles
beeves114615042bee_ves
beezers18349242beezers
bendees103913862bendees
bribees11409282bribees
freebees1345352freebees
peebeen1143902peebeen
peebeens1243062peebeens
peewees1236802peewees
teepees939262teepees
veepees1245812veepees
weewees1336562weewees
babbles104416323babbles
babels105216723b_abels
babes95834113b_ab_es
babies106123653b_abies
bailees93914383bailees
barbels114514433barbels
barbers114317503barbers
barbes104526233barb_es
barbets114915843barbets
barbies114519593barbies
bargees105415873bargees
baubee103215993baubee_
baubles113611863baubles
bawbee132714233bawbee_
beaches144120653beaches
beaders104120183beaders
beadles103414733beadles
beagles103212123beagles
beakers134216873beakers
beanies93821093beanies
bearers94619593bearers
beaters94925043beaters
beavers124417323beavers
bebeeru1144263bebeeru
bebeerus1242673bebeerus
bebops1237623b_ebops
beckets15399823beckets
becomes132911963becomes
bedbugs13193503bedbugs
bedders113513383bedders
bedels94015273b_edels
bedews12398943b_edews
bedless1039703bedless
beebread1343243beebread
beebreads1442823beebreads
beechen14367703beechen
beefed123510873bee_fed
beefier12329093beefier
beefiest13269013beefiest
beefless1335493beefless
beefs105618563b_e_efs
beehives1644483beehives
beelines103312803beelines
beeped115313453bee_ped
beeper103714093bee_per
beeps95320973b_e_eps
beerier93613023beerier
beeriest104013403beeriest
beers75628393b_e_ers
bees65453383___bees
beetle8311673beetle_
beetled1038213beetled
beetler938033beetler
beetlers1037393beetlers
beets76131443b_e_ets
beezer174010523bee_zer
befleas1236973befleas
befrets1237613befrets
begazes1937963begazes
begets96215523b_egets
behaves15198523behaves
behoves15177353behoves
beiges91014413b_eiges
beignes10149243beignes
bejabers1933633bejabers
bejeebers2042283bejeebers
bejewels2042493bejewels
belches143514343belches
beliefs12448583beliefs
beliers94617383beliers
belies84631053b_elies
believes13449403believes
belleek1347243belleek
belleeks1444363belleeks
belles85325993b_elles
bellies94023723bellies
belters93819413belters
bemires113212833bemires
bemixes18338653bemixes
bemuses1139293bemuses
benames112814603benames
benches143918603benches
bendee94121023bendee_
benders104021063benders
benes75536233b_e_nes
bennes86019013b_ennes
bennets94712163bennets
bennies93917313bennies
benzenes1946853benzenes
berakes134815773berakes
berates94126873berates
berberis1246603berberis
bereaves1338273bereaves
berets85822523b_erets
bergeres1189113bergeres
berimes115216643berimes
bermes106023003b_ermes
berries94423553berries
berseem1166463berseem
berseems1263933berseems
beseem1069083b_eseem
beseems1175913beseems
beses75830723b_e_ses
besets85718803b_esets
besides104814533besides
besieges1146003besieges
betakes134212523betakes
betels84515063b_etels
bethels1238533bethels
betides104915263betides
betimes115114413betimes
betises94816123betises
betters94422093betters
between1234683between
bevelers13389453bevelers
bevels113913983b_evels
bevies114017303b_evies
bewares12313373bewares
beweep13147253b_eweep
beweeps1494563beweeps
bezels173712283b_ezels
bibbers103911353bibbers
bibles104617643b_ibles
bilbies114712343bilbies
bilboes114410243bilboes
bimboes13498733bimboes
blebs96416153bleb__s
bleeders11448453bleeders
bleeds95211593ble_eds
bleepers12377493bleepers
bleeps10499103ble_eps
blendes104713683blendes
blesses93812393blesses
bobbers103614283bobbers
bobbies103714563bobbies
bobbles104514913bobbles
bombers134512593bombers
bombes124916823bomb_es
boobies113718203boobies
bootees94114473bootees
bredes94818473bre_des
breeches15258673breeches
breeders11368893breeders
breeds94914883bre_eds
breeks125310793bre_eks
brees75632553b__rees
breezes18318693breezes
breves115516423bre_ves
brevets12519393brevets
brewers123811063brewers
bribee104316363bribee_
bribers114111503bribers
bribes105918533brib_es
bubbies103913513bubbies
bubbles104315963bubbles
bubkes144612623b_ubkes
buboes104513993b_uboes
bulbels11398013bulbels
bumbles134016843bumbles
bungees104513103bungees
burbles114916803burbles
burgees104915893burgees
busbies113011693busbies
chebecs1635013chebecs
debyes1238103_debyes
decrees102513123decrees
deepens10307813deepens
degrees92810723degrees
derbies103016053derbies
djebels1753293djebels
ebbets10376833_ebbets
embeds11377903_embeds
embers104116183_embers
emcees1037813_emcees
epees75219833__epees
etwees9348793_etwees
feeble1138253feeble_
feebler1235823feebler
feeblest1336913feeblest
feebs106112683feeb__s
feeders113712863feeders
feelers103814743feelers
feeless103511103feeless
feezes184412613fee_zes
freebee1238043freebee_
freebies1337873freebies
geezers17286513geezers
gelees74116263_gelees
glebes95512243gleb_es
grebes93813613greb_es
hebes105521673_heb_es
heeders114213743heeders
heelers103815623heelers
heezes184211643hee_zes
jebels15418913_jebels
jeepers16399193jeepers
jeerers14328923jeerers
jezebels2641783jezebels
kebbies1537253kebbies
keeners113610783keeners
keepers133410983keepers
keeves133711993kee_ves
lebens8310093_lebens
leeches123911933leeches
lessees73510243lessees
levees93714523_levees
meeters94714543meeters
melees83618083_melees
members13258603members
mentees93214503mentees
mergees104411233mergees
mestees94617753mestees
needers84111903needers
needles83211563needles
newbies12147423newbies
pebbles1337573pebbles
peelers93615593peelers
peepers113713673peepers
peeress939503peeress
peeries93623023peeries
peeves113814873pee_ves
peewee11311963peewee_
pensees9311203pensees
pewees11311393_pewees
plebes104313623pleb_es
rebbes10313533_rebbes
rebecs103913673_rebecs
rebels84518133_rebels
reefers103312593reefers
reekers113613143reekers
reelers73520273reelers
reeves94721493ree_ves
referees111310413referees
resees63827483_resees
seabeds10417223seabeds
seedbeds12233703seedbeds
seeders83017113seeders
seekers113712333seekers
seemers93814333seemers
seeress7311573seeress
seethes103613743seethes
settees73513633settees
shebeen1234553shebeen
shebeens1343333shebeens
teemers95012903teemers
teeners74415453teeners
teepee8314363teepee_
teeters74018303teeters
teethes103611653teethes
tepees84215243_tepees
terebenes1146063terebenes
testees74215913testees
thebes115914493theb_es
trebles9311443trebles
veepee11311483veepee_
veeries102916893veeries
vendees114011453vendees
vestees103513173vestees
webers11310943_webers
weeders113412933weeders
weenies102915093weenies
weepers123511973weepers
weepies122811743weepies
weevers13379993weevers
weewee12310083weewee_
weeweed1435183weeweed
xebecs17355363_xebecs
zebecs19316183_zebecs

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.436409841.7
2DLD Change Limit1340272876.86019537.5
3Display Results2872870.0962989.6
 (SQL Overall)1786912877.39224173.6
 
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.