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

323 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
billows12361129(None) 
bellows124313301bellows
billons93013361billons
billow114111221billow_
billowy15366901billowy
pillows122610121pillows
willows13299751willows
allows94517682_allows
ballons93916962ballons
ballots94116032ballots
barlows12259982barlows
bellow114213352bellow_
belows114614182b_elows
bilboas11438732bilboas
bilboes114410242bilboes
bilbos105011202bilbo_s
bilious9310932bilious
billers94720832billers
billets94516152billets
billies93923502billies
billions102211792billions
billon83713832billo_n
billowed14137062billowed
bills75632862bill__s
blows105423832b__lows
brillos9369182brillo_s
bullous9311662bullous
fallows133713972fallows
fellows134212432fellows
fillos94415082fillo_s
follows13409922follows
gallows113513512gallows
hallows134417392hallows
hilloas104413552hilloas
hilloes103815962hilloes
hillos94618892hillo_s
hollows134412332hollows
mallows123714322mallows
mellows123812232mellows
pillow113110572pillow_
pillowy15316422pillowy
sallows103915552sallows
tallows103313742tallows
villous102810022villous
wallows133613532wallows
willow12369692willow_
willowy16276352willowy
yellows13329602yellows
airflows1443833airflows
airglows1243463airglows
allods73615083_allods
allots64019173_allots
allow85420663_allow_
alloys94014563_alloys
bailors93212413bailors
balboas113710073balboas
ballads104212913ballads
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballon84117493ballo_n
balloon93711433balloon
balloons103110523balloons
ballot84624093ballo_t
balls76236413ball__s
barlow112911433barlow_
barrows123411693barrows
beclogs1237073beclogs
beclown1435423beclown
beclowns1544683beclowns
bellboys1544523bellboys
belles85325993bell_es
bellhops1544873bellhops
bellies94023723bellies
bellowed14158613bellowed
bellower13159073bellower
bellowers14177623bellowers
bells76432163bell__s
belons84119413b_elons
below104617193b_elow_
besnows1245153besnows
bestows1248863bestows
bialies93618413bialies
bialis83617163bial_is
bialys11387913bial_ys
bibelots1295133bibelots
bibles104617643bibl_es
bibless11439173bibless
bibulous1244633bibulous
bicolors1256163bicolors
bicrons113410473bicrons
bields94110003biel_ds
bigos85020013bi_go_s
bigots95015133bi_gots
bijous1548043bi_jous
bilbies114712343bilbies
bilbo95513613bilbo__
bilboa10367843bilbo_a
biles75542143bi_l_es
bilges94915633bi_lges
bilkers134711863bilkers
bilks115117893bi_l_ks
bill67239943bill___
billbug1242753billbug
billbugs1342703billbugs
billed94224903bill_ed
biller84923483bill_er
billet86029723bill_et
billfish1645033billfish
billfold1443153billfold
billfolds1542773billfolds
billhook1743653billhook
billhooks1843233billhooks
billie85019173bill_ie
billing103823853billing
billings113412633billings
billion92212173billion
billowier1444293billowier
billowiest1543633billowiest
billowing1545873billowing
billy105525363bill__y
biltong1034683biltong
biltongs1133813biltongs
bimboes13498733bimboes
bimbos124610523bimbo_s
bingoes104013983bingoes
bingos95514793bingo_s
binocs1039923bi_nocs
biogs85016113bi__ogs
biology1337363biology
bios66335323bi__o_s
bipods11408593bi_pods
birlers93813003birlers
birles84920643birl_es
birls74023163birl__s
biros75325133bi_ro_s
bishops1437033bishops
bisons83914373bi_sons
blaws105620463b__laws
blobs95620033b__lobs
blocs95219653b__locs
blogs85319233b__logs
bloods94614843b_loods
blooms104613173b_looms
bloops106611343b_loops
blots75626173b__lots
blow95827193b__low_
blown105716673b__lown
blowsy14579453b__lowsy
blowy134315323b__lowy
bollocks1636503bollocks
bollox1548743bollo_x
bolloxes1736833bolloxes
bolls75531313boll__s
bolos75531373b_olo_s
bolsons969483bolsons
borrows12349263borrows
bouillons1143603bouillons
bows96242863b___ows
bowwows1454123bowwows
brillo84211003brillo__
brills84916293brill__s
brows105425983b__rows
brulots946223brulots
bugloss1035893bugloss
bulbous1138293bulbous
bulldogs1274243bulldogs
bullets93516393bullets
bullies94121893bullies
bullions101710043bullions
bullock1537193bullock
bullocks1636293bullocks
bulls75629573bull__s
burrows12399103burrows
byelaws1533263byelaws
bylaws14415833b_ylaws
callous93516603callous
callow114714663callow_
cellos84517803cello_s
collops112611753collops
dialogs938103dialogs
diglots9299503diglots
dildoes9229243dildoes
dildos8179303dildo_s
dillies84122163dillies
dills65530973dill__s
diploes101111493diploes
disallows1343393disallows
dollops10287963dollops
elbows1196723_elbows
fallow124713853fallow_
felloes104114383felloes
fellow123712743fellow_
fillers104320213fillers
filles94224523fill_es
fillets103414753fillets
fillies103420253fillies
fillips12298133fillips
fillo84319783fillo__
fills84632373fill__s
filos86125383fi_lo_s
flows115822363__flows
follow124010353follow_
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
giglots9367863giglots
gillers84216903gillers
gillies84120963gillies
gills64728193gill__s
glows95518033__glows
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallow124818323hallow_
helloes103717473helloes
hellos95321683hello_s
hillers103718733hillers
hillo84721653hillo__
hilloa94713033hillo_a
hillock1646693hillock
hillocks1736063hillocks
hilloed113211293hilloed
hills85431353hill__s
hilltops1344933hilltops
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollow124212663hollow_
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
igloos738033_igloos
ills47030423_ill__s
indows104210793_indows
inflows1335523inflows
jellos134714283jello_s
jillions15178283jillions
jills125122823jill__s
killers114215583killers
killies113318113killies
killjoys2242033killjoys
killock1255253killock
killocks1354793killocks
kills94526173kill__s
kilos95021473ki_lo_s
lilos55821873li_lo_s
lollops9227443lollops
lows75843013___lows
maillots1037473maillots
mallow114014743mallow_
mellow114112223mellow_
miaows1145473mi_aows
mildews13365883mildews
millers93621343millers
milles84526563mill_es
millets94216843millets
millions101712433millions
mills75435053mill__s
milos75428013mi_lo_s
minnows1234913minnows
niellos736143niello_s
nills54926673nill__s
pallors9314363pallors
pilaws11399433pi_laws
pileous9510523pileous
pillars9313493pillars
pillions101610923pillions
pillory12247453pillory
pillowed14156383pillowed
pills74130973pill__s
pilots84018873pi_lots
pilous84717753pi_lous
plows105419903__plows
reflows13258983reflows
reglows11288843reglows
replows12329703replows
rilles64725503rill_es
rillets74216153rillets
rills55032713rill__s
sallow94315753sallow_
sallowy13369343sallowy
shallows14388863shallows
siglos7311473siglo_s
sillers73822103sillers
sillies73425083sillies
sills55135993sill__s
silos56029433si_lo_s
slows85323463__slows
swallows14295893swallows
tallols73311363tallols
tallow93714203tallow_
tallowy13347633tallowy
tiglons837343tiglons
tillers73418743tillers
tills54631713till__s
upflows1543513upflows
villas96117263vill_as
villose1038053villose
vills86429323vill__s
villus93611223vill_us
wallops123410413wallops
wallow123913513wallow_
whitlows1743093whitlows
widows1376563wi_dows
willers103517913willers
willets104414323willets
willies103920153willies
willowed15156773willowed
willower14127463willower
willowers15166693willowers
wills84528963will__s
windows1447743windows
winnows1334533winnows
yellow12429883yellow_
yellowy16255693yellowy
yills83921553yill__s
zillahs1935383zillahs
zillions17168073zillions
zills144020783zill__s

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.403443402.0
2DLD Change Limit1340273237.11018850.5
3Display Results3233230.1102936.4
 (SQL Overall)1786913237.62323441.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.