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 “boars” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

277 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
boars7522960(None) 
bars66564091b_ars
bears75739041bears
boar66134291boar_
board85523001board
boards94616931boards
boart78835931boart
boarts84716871boarts
boas66150831boa_s
boats75635151boats
boors74325011boors
boras75938301boras
boyars115611981boyars
hoars85925551hoars
oars46846031_oars
roars55622241roars
soars54732511soars
aboard9312612aboard
afars85716512afars
agars66120642agars
ars37670932__ars
baals76122702baals
baas66844672b_aas
bads77048862b_ads
bags76645502b_ags
bals66354042b_als
bams87044452b_ams
bans66555142b_ans
baps86040842b_aps
bar58070552b_ar_
barb85240062b_arb
barbs95928192b_arbs
bard75648862b_ard
bards87139642b_ards
bare65460522b_are
bares75457132b_ares
barf95844412b_arf
barfs104826002b_arfs
bark106242152b_ark
barks115735812b_arks
barm86739602b_arm
barms96128462b_arms
barn66444642b_arn
barns76335142b_arns
bas58681752b_a_s
bass66146782b_ass
bats66962332b_ats
bays97143912b_ays
bazars174613112bazars
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bear66844642bear_
beard86024962beard
beards94116672beards
beats76042242beats
beaus75127112beaus
beers75628392beers
bezoars1836792bezoars
bias64738162bia_s
biers76225222biers
birrs74917102birrs
blabs95619632blabs
blahs105616512blahs
blams95023852blams
blare75826232blare
blares85021632blares
blats75132502blats
blaws105620462blaws
blears85116452blears
bloats85215762bloats
blurs74619082blurs
boa56954032boa__
boarish123911912boarish
boast75935702boast
boasts85017922boasts
boat66360312boa_t
boaters93419242boaters
bobs86340652bo_bs
bocks134526572bocks
bodes84935102bodes
bods76244712bo_ds
boffs134915502boffs
bogans95714812bogans
bogart9617192bogart
bogarts1047742bogarts
bogs75742752bo_gs
bogus85616472bogus
bohos105618252bohos
boils75427192boils
bolar75123472bolar_
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bombs115818822bombs
bonds86126842bonds
boners84825432boners
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boor66130682boor_
boos67955032bo_os
boots75837972boots
bops86037982bo_ps
bora66141632bo_ra
boral75831702boral
borals86721912borals
borax145918722borax
bore66051332bo_re
borers85122682borers
bores76448252bores
bork106933822bo_rk
borks115727702borks
born67338412bo_rn
bort65960962bo_rt
borts76735452borts
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
botas75328782botas
bots66453952bo_ts
botts75224862botts
bourg84113842bourg
bourgs9459992bourgs
bourn75518482bourn
bourns84114062bourns
bourse84414332bourse
bouts75131312bouts
bowers115523702bowers
bowls106121432bowls
bows96242862bo_ws
boxcars1834772boxcars
boxers155013482boxers
boxes145625072boxes
boyar106013762boyar_
boyard125411282boyard
boyards13399322boyards
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
briars84814822briars
broads94515152broads
buhrs104811242buhrs
buras74736302buras
burrs74925652burrs
burs65847422b_urs
cars67364762_cars
chars105936642chars
coals76129602coals
coarse84813902coarse
coats75635002coats
coirs75221052coirs
cors66656442co_rs
czars164812912czars
dears65736882dears
doats65224882doats
doers65225712doers
doors65022132doors
dorrs65520592dorrs
dors56747602do_rs
ears46356592_ears
fears84829392fears
fiars86720832fiars
foals85721692foals
foams105017952foams
fours85521492fours
gars55750742_gars
gears64628692gears
gnars66718852gnars
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
goers65520252goers
guars65021052guars
haars85620472haars
hears86737372hears
hoar76729162hoar_
hoard94918312hoard
hoards104912622hoards
hoarse94411322hoarse
hoary114516762hoary
hoers85724922hoers
horas86333102horas
hours85422392hours
izars145112932izars
jars117338352_jars
jowars16369652jowars
kbars114612602kbars
knars94416112knars
koans95818622koans
koas85635092koa_s
koras95927112koras
kors85933012ko_rs
kyars124813962kyars
lars46956572_lars
lears55938732lears
liars54723162liars
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
lours55125292lours
maars74621632maars
mars66261872_mars
moans74624372moans
moas65545342moa_s
moats75827642moats
molars85517322molars
moors74923142moors
moras76438782moras
mors65950062mo_rs
nears55529422nears
noirs55615462noirs
oafs76425262_oafs
oaks86527902_oaks
oar37057952_oar_
oats46554212_oats
obas65730932oba_s
ors35750112_o_rs
ours47237562_ours
pars67560792_pars
pears75138612pears
polars84419352polars
pours74623182pours
rears54739652rears
roads66523622roads
roams74919612roams
roans54926442roans
roar46328572roar_
scars75433532scars
sears54744912sears
soaks95220292soaks
soaps75120712soaps
soar46838672soar_
sofars94712782sofars
sonars64818972sonars
soras55041012soras
sours55230502sours
sowars94318012sowars
spars75431542spars
stars55836572stars
tars46763952_tars
tears55436462tears
toads65621072toads
tolars64817942tolars
toras55540372toras
torrs53923562torrs
tors46157382to_rs
tours55325892tours
tsars56717112tsars
tzars144914272tzars
vars75742072_vars
wars78659802_wars
wears86030302wears
woads94818442woads
years84527672years
yours85217882yours

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538002771.44037361.1
3Display Results2772770.0763644.7
 (SQL Overall)1786912771.81298615.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.