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

393 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
barlows1225997(None) 
barlow112911421barlow_
barrows123411681barrows
allows94517682_allows
arrows92813482_arrows
bailors93212412bailors
ballons93916962ballons
ballots94116032ballots
barhops14288112barhops
barless94317002barless
barleys125011842barleys
barons85025382bar_ons
barrow114512762barrow_
baryons121010472baryons
bellows124313302bellows
belows114614182b_elows
billows123611292billows
blows105423832b__lows
borrows12349252borrows
brows105425982b_r_ows
burrows12399092burrows
fallows133713972fallows
farrows13259782farrows
gallows113513512gallows
hallows134417392hallows
harlots103413292harlots
harrows132611032harrows
mallows123714322mallows
marrows122911822marrows
narrows10258842narrows
parlors9312912parlors
parlous9414292parlous
sallows103915552sallows
tallows103313742tallows
wallows133613532wallows
yarrows13277852yarrows
aglow94711973_aglow_
airflows1443833airflows
airglows1243463airglows
allods73615083_allods
allots64019173_allots
allow85420663_allow_
alloys94014563_alloys
aloes54933673_a_loes
alow75328593_a_low_
arbors84717883_arbors
ardors74416873_ardors
argols74514613_argols
argons75018203_argons
argots74116033_argots
arles56735743_arl_es
armors85017813_armors
arrow83414883_arrow_
arrowy12288273_arrowy
arsons63917213_arsons
arvos86015663_arvo_s
avows114910983_a_vows
azlons154110423_azlons
baals76122703baal__s
babools11319453babools
baboons113211083baboons
baboos103517013ba_boos
backflows2343873backflows
backlogs1746633backlogs
bacons104917583ba_cons
bailees93914383bailees
bailers94221353bailers
baileys12388933baileys
bailies94120203bailies
bailor83412603bailo_r
bailout9414133bailout
bailouts1036613bailouts
bails75933523bail__s
baklawa1643403baklawa
baklawas1743213baklawas
balas76937213ba_l_as
balboas113710073balboas
balds85524643ba_l_ds
balers85626933ba_lers
bales76250083ba_l_es
balks114926293ba_l_ks
ballads104212913ballads
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballon84117493ballo_n
balloon93711433balloon
balloons103110523balloons
ballot84624093ballo_t
balls76236413ba_l_ls
balms95723923ba_l_ms
bals66354043ba_l__s
balsas86417523ba_lsas
bamboos1348753bamboos
bancos104713893banco_s
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893banjo_s
barbels114514433barbels
barbers114317503barbers
barbes104526233bar_bes
barbets114915843barbets
barbies114519593barbies
barbless12318713barbless
barbs95928193bar__bs
barbuts11439843barbuts
barcas101016603bar_cas
bardes95026933bar_des
bards87139643bar__ds
bareges105212033bareges
bares75457133bar__es
barflies1338303barflies
barfs104826003bar__fs
bargees105415873bargees
barges94528253bar_ges
barhop13319643barho_p
barillas10310193barillas
barites94322333barites
bariums1139143bariums
barkers134318513barkers
barkless14318023barkless
barks115735813bar__ks
barley115116763barl_ey
barms96128463bar__ms
barneys12569563barneys
barns76335143bar__ns
baron78131243bar_o_n
barong96015823bar_ong
barongs105310833barongs
barony115915303bar_ony
barques18259643barques
barrels94514363barrels
barrens94414323barrens
barres84427543bar_res
barrets94917103barrets
barrios9310773barrios
barroom1139373barroom
barrooms1237893barrooms
bars66564093bar___s
barters94223033barters
baryes116218503bar_yes
baryon111211613baryo_n
barytas12378283barytas
barytes124611153barytes
barytons1345573barytons
bashaws15347713bashaws
basions94213953basions
bassos85313703basso_s
batboys1465833batboys
batfowl1543593batfowl
batfowls1642773batfowls
bathos116215633batho_s
batons85519423ba_tons
baulks12429373baul_ks
bawlers124412733bawlers
bawls105719323bawl__s
bayous11411153ba_yous
bazooms20285383bazooms
bazoos173212623ba_zoos
beclogs1237073beclogs
beclown1435423beclown
beclowns1544683beclowns
bellow114213353bellow_
belons84119413b_elons
below104617193b_elow_
berlins93216013berlins
besnows1245153besnows
bestows1248863bestows
billons93013363billons
billow114111223billow_
billowy15366903billowy
birlers93813003birlers
birles84920643birl_es
birls74023163birl__s
biros75325133bir_o_s
blaws105620463b__laws
blobs95620033b__lobs
blocs95219653b__locs
blogs85319233b__logs
blots75626173b__lots
blow95827193b__low_
blown105716673b__lown
blowsy14579453b__lowsy
blowy134315323b__lowy
bolos75531373b_olo_s
borons85520543bor_ons
borrow114310723borrow_
borzois1835833borzois
bows96242863b___ows
bowwows1454123bowwows
braless92910563braless
bravoes12418533bravoes
bravos114711393bravo_s
braws106425193b_r_aws
brews105617073b_r_ews
brios74725723b_rio_s
broods95416383b_roods
brooks125813883b_rooks
brooms104915873b_rooms
broos75126413b_r_oos
bros65635663b_r_o_s
brow97228443b_r_ow_
brown105619533b_r_own
browns116415633b_r_owns
browse115713853b_r_owse
brulots946223brulots
bugloss1035893bugloss
bullous9311663bullous
burbots1168673burbots
burgoos1037123burgoos
burlaps1156253burlaps
burlers94120273burlers
burleys12479673burleys
burls74228853burl__s
burnous938823burnous
burros85114993burro_s
burrow114610803burrow_
burtons9310853burtons
byelaws1533263byelaws
bylaws14415833b_ylaws
byrls105711233byrl__s
cahows14399123ca_hows
callous93516603callous
callow114714663callow_
calos74431903ca_lo_s
carbons115418943carbons
carbos105122263carbo_s
carboys144711783carboys
cardons104519943cardons
cargoes104415223cargoes
cargos94619183cargo_s
carhops14329703carhops
carious93320283carious
carles85435083carl_es
carless95118493carless
carlins93921923carlins
carload1039783carload
carloads1138393carloads
carls77037423carl__s
carobs104818103car_obs
carols85124983car_ols
carolus94612603carolus
caroms105619573car_oms
carroms11512403carroms
carrots9714623carrots
cartons94122473cartons
crows105727313_cr_ows
curlews12387393curlews
dayglows1641953dayglows
earlaps936393earlaps
earldoms1144223earldoms
earless74316073earless
earlobe946543earlobe
earlobes1056143earlobes
earlock1336923earlock
earlocks1435693earlocks
earls56127513earl__s
fallow124713853fallow_
farles96025783farl_es
farls85731113farl__s
faros85532023far_o_s
farrow12309973farrow_
fellows134212433fellows
flows115822363__flows
follows13409923follows
frows116623103_fr_ows
furrows13327793furrows
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
galops94712623ga_lops
garcons102411643garcons
garlics1038013garlics
garrons82713463garrons
glows95518033__glows
grows95523923_gr_ows
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallow124818323hallow_
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
harbors12412413harbors
harlot94422803harlo_t
harls85634503harl__s
harrow122610773harrow_
haymows1883813haymows
hollows134412333hollows
inflows1335523inflows
jailors14328753jailors
jalops15329593ja_lops
jargons1558203jargons
jarldoms1842943jarldoms
jarls126120963jarl__s
karoos102415803kar_oos
kaross101910013kar_oss
karroos1139313karroos
lardons83914493lardons
largos74815063largo_s
lows75843013___lows
mallow114014743mallow_
marlins93420473marlins
marls75535163marl__s
marmots11311513marmots
maroons92615553maroons
marplots1245633marplots
marrons93216973marrons
marrow112812603marrow_
marrowy15236083marrowy
mellows123812233mellows
merlons93311273merlons
merlots92710123merlots
morrows12318723morrows
narcos86714203narco_s
narrow9269143narrow_
oarless73913373oarless
oarlock1336123oarlock
oarlocks1445103oarlocks
orlons6411013_orlons
orlops847303_orlops
pallors9314363pallors
pardons103817623pardons
pareos87023773pareo_s
pargos95719043pargo_s
parlays123910453parlays
parles86334403parl_es
parleys125212373parleys
parlor8312673parlo_r
parlour937263parlour
parlours1036153parlours
paroles95025883paroles
parols84722613par_ols
parous84024163par_ous
parrots9312743parrots
parsons93516873parsons
partons94620513partons
parvos116614753parvo_s
pillows122610123pillows
plows105419903__plows
prows106327013_pr_ows
reflows13258983reflows
reglows11288843reglows
replows12329703replows
rows75941753__r_ows
sailors73213723sailors
sallow94315753sallow_
sallowy13369343sallowy
salols64017873sa_lols
salons63823693sa_lons
sarcous9312933sarcous
sargos74318273sargo_s
sarods74918573sar_ods
saros55238063sar_o_s
sartors7314973sartors
sawlogs1135393sawlogs
serows96016393ser_ows
shallows14388863shallows
slows85323463__slows
sorrows10278403sorrows
sparrows1344803sparrows
strows96718273str_ows
swallows14295893swallows
tailors73212393tailors
tallols73311363tallols
tallow93714203tallow_
tallowy13347633tallowy
talons64019443ta_lons
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar_o_s
tarots66422993tar_ots
tarpons92612213tarpons
throws129715233thr_ows
trows88826183_tr_ows
upflows1543513upflows
valors93413773va_lors
various103113103various
varlets10411573varlets
varooms1248883varooms
vrows116115263_vr_ows
wallops123410413wallops
wallow123913513wallow_
warless104015103warless
warlock1636293warlock
warlocks1735363warlocks
warlord1136293warlord
warlords1245303warlords
warsaws1335763warsaws
willows13299753willows
yarrow12287933yarrow_
yellows13329603yellows

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.406440125.6
2DLD Change Limit1340273936.00022337.8
3Display Results3933930.1402807.1
 (SQL Overall)1786913936.54627297.7
 
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.