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 “bezoars” 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
bezoars183679(None) 
bezoar1736911bezoar_
bazaars18275882bazaars
bazars174613112baz_ars
bears75739042be__ars
beggars11378222beggars
bemoans1138252bemoans
bevors111610342bevo_rs
boars75229602b__oars
bars66564093b___ars
bazaar17306403bazaar_
bazar163816003baz_ar_
bazooms20285383bazooms
bazoos173212623bazo_os
beaders104120183beaders
beads85429503be__ads
beakers134216873beakers
beaks115326623be__aks
beams95328173be__ams
beans75734693be__ans
bear66844643be__ar_
beard86024963be__ard
beards94116673be__ards
bearers94619593bearers
beaters94925043beaters
beats76042243be__ats
beaus75127113be__aus
beavers124417323beavers
bebops1237623bebo_ps
becaps123811403be_caps
becharm1636843becharm
becharms1745343becharms
becloaks1644933becloaks
becomes132911963becomes
becoward1644763becoward
becowards1743843becowards
bedboard14115723bedboard
bedboards15114873bedboards
bedders113513383bedders
bedlams1237053bedlams
bedpans1237173bedpans
bedward1497473bedward
bedwards1596393bedwards
bedwarf16106463bedwarf
bedwarfs17113583bedwarfs
beepers113612383beepers
beers75628393be__ers
beeyard1335523beeyard
beeyards1444593beeyards
beezers18349243beezers
beflags1355493beflags
befogs1246453befo_gs
befools1236433befools
before11410153befo_re
befouls1236053befouls
beggar10328223beggar_
beggary14316153beggary
beglads11127263beglads
begorah1355593begorah
begorra1043543begorra
begroans1145503begroans
beheads1338523beheads
beholds1336423beholds
behoves15177353behoves
behowls1534443behowls
belays114313853be_lays
beldams1237053beldams
beleaps1138053beleaps
belgas9311713belga_s
beliers94617383beliers
belongs10408223belongs
belons84119413belo_ns
belows114614183belo_ws
belters93819413belters
bemas96424283be_ma_s
bemeans1148743bemeans
bemoan10310253bemoa_n
bemocks1735373bemocks
bendays13327513bendays
benders104021063benders
benzoate1944883benzoate
benzoates2044093benzoates
benzoins1945573benzoins
benzoles1936993benzoles
benzols1836673benzo_ls
benzoyls2242443benzoyls
bescours1245093bescours
besmears1234543besmears
besoms105712733beso_ms
besots86415453beso_ts
bestirs9311133bestirs
beswarm1445783beswarm
beswarms1544323beswarms
betas75528763be_ta_s
betons84919553beto_ns
betrays12127823betrays
bettas84913923betta_s
betters94422093betters
bettors93312473bettors
bevor101510813bevo_r_
beware11313713be_ware
bewares12313373be_wares
beweary1536223beweary
beworm1339993bewo_rm
beworms1437933beworms
beworry1543743beworry
bewraps14135403bewraps
bewrays15145113bewrays
beyonds1335063beyonds
bezant17814543bez_ant
bezants1877343bezants
bezazz1543983bez_azz
bezels173712283bez_els
bezils1711310603bez_ils
bezzant1746893bezzant
bezzants1843643bezzants
bizones1837823bizones
blears85116453b_lears
bloats85215763b_loats
boar66134293b__oar_
board85523003b__oard
boards94616933b__oards
boart78835933b__oart
boarts84716873b__oarts
boas66150833b__oa_s
boats75635153b__oats
boors74325013b__oors
boozers183912443boozers
boras75938303b__oras
boxcars1834773boxcars
boyars115611983b_oyars
bozos165216863bozo__s
briars84814823b_riars
broads94515153b_roads
bursars94510893bursars
busbars1138153busbars
buzzard1844273buzzard
buzzards1943613buzzards
buzzers17347173buzzers
byroads1335293byroads
cedars93312833ce_dars
cellars93713693cellars
czars164812913_cz_ars
dears65736883de__ars
debars94218043de_bars
decors94017773deco_rs
defoams1336193defoams
denars74621433de_nars
deodars937623deodars
detours858043detours
devoirs1175783devoirs
devours1166643devours
dewars105117073de_wars
ears46356593_e__ars
eggars8398973_eggars
embars103812883_embars
escars83913133_escars
eskars10357593_eskars
fears84829393fe__ars
fedoras1137923fedoras
fetors91014473feto_rs
feuars938653fe_uars
gazars164811553gaz_ars
gears64628693ge__ars
genoas74013623genoa_s
hears86737373he__ars
hoars85925553__hoars
izars145112933_iz_ars
kebars124112493ke_bars
lazars153812393laz_ars
lears55938733le__ars
lekvars1432693lekvars
medlars10259443medlars
memoirs1136803memoirs
mezcals20246543mezcals
nears55529423ne__ars
nectars938463nectars
oars46846033___oars
pears75138613pe__ars
pedlars103210213pedlars
razors154711663razo_rs
rears54739653re__ars
rebars84019833re_bars
reboard10310763reboard
reboards1138773reboards
recoals94214623recoals
recoats92616643recoats
redears82814453redears
regears83012463regears
rehears103312773rehears
reloads8911313reloads
reloans7313133reloans
remoras9314073remoras
repours9310233repours
resoaks1148973resoaks
retears72814923retears
rewears102911043rewears
rezones163213943rezones
roars55622243__roars
sears54744913se__ars
secpars1138413secpars
seggars9377783seggars
seizors16329013seizo_rs
senoras72714953senoras
senors63620793seno_rs
serovars1145233serovars
sewars94018633se_wars
sizars154812623siz_ars
soars54732513__soars
tears55436463te__ars
tenors63217753teno_rs
tenours72610073tenours
tzars144914273_tz_ars
uproars986453uproars
upsoars985413upsoars
velars93913723ve_lars
velours10278083velours
vetoers10359473vetoers
vizors18328903vizo_rs
wears86030303we__ars
years84527673ye__ars
zedoary2043213zedoary

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.390458182.1
2DLD Change Limit1340272226.37321030.4
3Display Results2222220.0802775.0
 (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.