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

286 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
beweep1314725(None) 
beweeps1494561beweeps
beep85931212b__eep
beleap10410282beleap
beseem1069082beseem
between1234682between
bewept13410322bewept
bewrap13157052bewrap
bleep95013452b_leep
bopeep1236762bopeep
pewee10319972pewee_
pewees11311392pewees
sweep104715722_sweep
weep95131652__weep
asleep847283asleep
atween9166613atween
awee76336643_awee_
baleen8613053baleen
barkeep1536363barkeep
bawbee132714233bawbee
bawbees14337243bawbees
bawled124415693bawled
bawler114315053bawler
beaded104922423beaded
beader94623793beader
beaked135919493beaked
beaker125520693beaker
beamed115720733beamed
beaned95621473beaned
bearer85323913bearer
beaten84617063beaten
beater84729393beater
beaver114819253beaver
bebeeru1144263bebeeru
bebop11410793be_bop
becap114315053be_cap
becked155417763becked
becket144619883becket
bedded115114063bedded
bedder104215783bedder
bedeck1536213bedeck
bedel84219393be_del
bedell93610043bedell
bedels94015273bedels
bedemen12910183bedemen
bedew114513033be_dew
bedewed1437153bedewed
bedews12398943bedews
bee56262403b__ee_
beebee10313063beebee
beebees1138013beebees
beech124315503be_ech
beedi8711663be_edi
beef96233683b__eef
beefed123510873beefed
beefs105618563be_efs
beefy135313833be_efy
been65335783b__een
beeped115313453beeped
beeper103714093beeper
beeps95320973be_eps
beer65635993b__eer
beers75628393be_ers
beery105220123be_ery
bees65453383b__ees
beet66457543b__eet
beets76131443be_ets
beeves114615043beeves
beezer174010523beezer
befell11428713befell
beflea1147123beflea
befret11315963befret
beget85632553be_get
begets96215523begets
begged115013803begged
behead1239923behead
beheld1236413beheld
behest11314613behest
beige81515373beige_
beiges91014403beiges
bejewel1953033bejewel
beleaps1138053beleaps
beleapt11310253beleapt
belie75630383belie_
belied95022163belied
belief115018603belief
belier84423563belier
belies84631053belies
belle75827833belle_
belled94626183belled
belleek1347243belleek
belles85325993belles
belted94020633belted
belter84720963belter
bemean10410683bemean
bended105521233bended
bendee94121023bendee
bendees103913863bendees
bender95223303bender
bene66439493be_ne_
benempt1346263benempt
benes75536233be_nes
benne76521123benne_
bennes86019013bennes
bennet84823363bennet
bereft114317303bereft
beret74946363be_ret
berets85822523berets
berme96022943berme_
bermed115217723bermed
bermes106023003bermes
berseem1166463berseem
beseech1453873beseech
beseems1175913beseems
beses75830723be_ses
beset76739133be_set
besets85718803besets
bested94922753bested
betel74419903be_tel
betels84515063betels
bethel1169643bethel
betted94721163betted
better84723703better
bevel104517043be_vel
beveled133811123beveled
beveler124010683beveler
bevels113913983bevels
bevies114017303bevies
bewail1189583bewail
beware11313713beware
bewared13310113bewared
bewares12313373bewares
beweary1536223beweary
beweeping1743933beweeping
bewig1138903bew_ig
bewigs1246533bewigs
beworm1339983beworm
bewraps14135403bewraps
bewrapt14147133bewrapt
bewray14147733bewray
bezel165215173be_zel
bezels173712283bezels
bicep115413543b_icep
bleed85019803b_leed
bleeps10499103b_leeps
blueweed1444043blueweed
bopeeps1333103bopeeps
boreen8314313boreen
bowed114533423bow_ed
bowel105621203bow_el
boweled132810693boweled
bowels114315593bowels
bower107328183bow_er
bowered133113043bowered
bowers115523703bowers
bowery146012113bowery
bowled125018133bowled
bowleg12369173bowleg
bowler114217313bowler
bowmen1399853bowmen
bowse105420633bowse_
bowsed125715973bowsed
bowses115718863bowses
bowyer14368923bowyer
bree67241263b_ree_
breed85526693b_reed
brees75632553b_rees
brewed125411873brew_ed
brewer114812543brew_er
brewers123811053brewers
brewery15376953brewery
burweed1347823burweed
cheep125416503_cheep
creep95218103_creep
deep76031883__deep
dewed105020303dew_ed
dewier104013463dewier
dewlap1264843dewlap
dweeb1137743_dweeb
dyeweed1543203dyeweed
emeer74815363_emeer
epee64628503_epee_
epees75219833_epees
etwee84115333etwee_
etwees9348793etwees
ewe66630983_ew_e_
ewer77523983_ew_er
ewers86018823_ewers
ewes76328703_ew_es
fewer115216123few_er
fewest12311663fewest
gelee63626983gelee_
gelees74116263gelees
hewed125619433hew_ed
hewer115719933hew_er
hewers123715273hewers
jeep135624843__jeep
jereed144012063jereed
jewed165114833jew_ed
jewel156711703jew_el
jeweled1845323jeweled
jeweler1735053jeweler
jewels16508613jewels
keep106329813__keep
kelep116014553ke_lep
kreep114610413_kreep
levee84023813levee_
leveed104111373leveed
levees93714523levees
lewder10479613lewder
melee73729103melee_
melees83618083melees
mewed115218013mew_ed
mewled123710053mewled
mewler113510233mewler
neep65728313__neep
newel86114133new_el
newels93710823newels
newer85717463new_er
newest9314213newest
newie81813483newie_
newies91014073newies
ngwee9311073ngwee_
outweep1236673outweep
peep85833693__peep
peesweep1541633peesweep
peewee11311963peewee
peewees1236803peewees
pewter114013673pewter
redeem9311523redeem
refeed104717623refeed
refeel93913243refeel
reheel93610823reheel
remeet86325473remeet
resee54336333resee_
reseed74823293reseed
reseek103813133reseek
reseen64318413reseen
resees63827483resees
rewear93011993rewear
rewed95425453rew_ed
reweds104412303reweds
reweld103711113reweld
rewet85135153rew_et
rewets94617213rewets
rewrap11127533rewrap
seaweed11108813seaweed
seep66540343__seep
sewed95325163sew_ed
sewer84426213sew_er
sewered112911243sewered
sewers94719713sewers
sheep105321523_sheep
sleep74920183_sleep
steep76020703_steep
sweeps114110513_sweeps
sweepy14447453_sweepy
sweer84918573_sweer
sweet85330523_sweet
tepee74724213tepee_
tepees84215243tepees
tewed94718533tew_ed
threep115910113threep
twee76827083_twee_
tweed94915093_tweed
tween84413743_tween
tweet84823983_tweet
twerp10398413_twerp
upkeep1434143upkeep
upsweep1442573upsweep
veep95325093__veep
veneer94511693veneer
wee66760813__wee_
weed85637513__weed
week116428153__week
weel75834083__weel
ween75835463__ween
weeps104120563__weeps
weepy134212593__weepy
weer75535093__weer
wees76249123__wees
weet75254153__weet
weewee12310083weewee
weeweed1435183weeweed
weewees1336563weewees
wheep136214353_wheep

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162866.56317174.5
3Display Results2862860.1102600.0
 (SQL Overall)1786912866.81326227.9
 
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.