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

509 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
billon8371383(None) 
ballon84117491ballon
billion92212171billion
billons93013361billons
billow114111221billow
ballons93916962ballons
balloon93711432balloon
ballot84624092ballot
bellow114213352bellow
belon73924112b_elon
bicron103710772bicron
bilbo95513612bilbo_
bilboa10367842bilboa
bilbos105011202bilbos
bill67239942bill__
billed94224902billed
biller84923482biller
billet86029722billet
billie85019172billie
billing103823852billing
billions102211792billions
billows123611292billows
billowy15366902billowy
bills75632862bill_s
billy105525362bill_y
biltong1034682biltong
bison75716982bi_son
bollox1548742bollox
bolson8410682bolson
bouillon1043782bouillon
brillo84211002brillo_
brillos9369182brillos
bullion91911032bullion
fillo84319782fillo_
fillos94415082fillos
gallon73715812gallon
hillo84721652hillo_
hilloa94713032hilloa
hillos94618892hillos
jillion14188932jillion
million91813142million
pillion92011702pillion
pillow113110572pillow
tiglon737922tiglon
willow12369692willow
zillion16188772zillion
aileron739833aileron
allod64418383_allod
allot54933873_allot
allow85420663_allow
alloy85519973_alloy
azlon144312873_azlon
baboon103613913baboon
bacon95620593b_acon
bailor83412603bailor
balboa10389963balboa
balcony1435853balcony
baleen8613053baleen
ball66043323ball__
ballad94315323ballad
balled94926893balled
baller83825203baller
ballet84733973ballet
balling104424763balling
ballonet10314503ballonet
ballonne1045243ballonne
balloons103110523balloons
ballots94116033ballots
balls76236413ball_s
ballsy11508873ballsy
bally105530103ball_y
barlow112911423barlow
baron78131243b_aron
baryon111211613baryon
basion84315853basion
baton75822423b_aton
bazillion2043273bazillion
beacon10511373beacon
beckon14309383beckon
beclog1136863beclog
beclown1435423beclown
bell66237183bell__
bellboy1445123bellboy
belle75827833bell_e
belled94626193belled
belles85325993belles
bellhop1445053bellhop
belling103825073belling
bellman1137183bellman
bellmen1138143bellmen
bellows124313303bellows
bells76432163bell_s
belly104625493bell_y
belong93411043b_elong
belons84119413b_elons
below104617193b_elow
berlin83116373berlin
beton76022063b_eton
biali73419073bial_i
bialis83617163bialis
bialy105119323bial_y
bialys11387913bialys
biathlon13153013biathlon
bibelot1167343bibelot
bible95119423bibl_e
bibles104617643bibles
bicolor1145613bicolor
bicorn103610103bicorn
bicrons113410473bicrons
bidden104010793bidden
bield84614653biel_d
bields94110003bields
biffin14369103biffin
biflex1834953biflex
bifold1237223bifold
biggin103710603biggin
bighorn1346063bighorn
bigly114814753bigl_y
bigos85020013bi_gos
bigot84828323bi_got
bijou1458793bi_jou
bilboas11438733bilboas
bilboes114410243bilboes
bilby124912353bi_lby
bile66147183bi_l_e
biles75542143bi_les
bilge87618913bi_lge
bilged105513183bilged
bilges94915633bilges
bilging114212683bilging
bilgy114713713bi_lgy
bilious9310933bilious
bilk105824423bi_l_k
bilked134012943bilked
bilker124913443bilker
bilking144413553bilking
bilks115117893bi_lks
billabong1441963billabong
billbug1242753billbug
billers94720833billers
billets94516153billets
billfold1443153billfold
billhook1743653billhook
billies93923503billies
billings113412633billings
billionth1444163billionth
billowed14137063billowed
billowing1545873billowing
billycan1543223billycan
biltongs1133813biltongs
bimbo114811873bimbo_
bimbos124610523bimbos
bin56658643bi___n
bingo86020093bingo_
bingos95514793bingos
bio57846083bi__o_
biog76122323bi__og
biogen9310253biogen
biology1337363biology
biont7727163bi__ont
bios66335323bi__os
biotin83215833biotin
biotron937293biotron
biplane1139033biplane
bipod104410823bi_pod
birl65830473birl__
birle75023633birl_e
birled94416993birled
birler85715083birler
birles84920643birles
birling104317053birling
birls74023163birl_s
biro66131213bi_ro_
biros75325133bi_ros
bishop1336943bishop
bisons83914373bi_sons
bitten84715123bitten
bizone1738603bi_zone
blain75421793b_lain
blawn106813703b_lawn
blazon1736763blazon
blin67228173b__lin
blob86027093b__lob
bloc85023273b__loc
blog75723823b__log
blond85618373b__lond
blood85319523b_lood
bloom95918973b_loom
bloop96116153b_loop
blot65842323b__lot
blow95827193b__low
blown105716673b_lown
boll65634753boll__
bolled94722653bolled
bolling103820883bolling
bollix1538053bollix
bolls75531313boll_s
bolo65535953b_olo_
bolos75531373b_olos
bolsons969483bolsons
bonbon10310073bonbon
boon67142173b__oon
boron76727143b_oron
boson76019733b_oson
boston8513043boston
bouillons1143603bouillons
bouton8311533bouton
bridoon1046203bridoon
brill74819953brill__
brills84916293brill_s
brulot8912213brulot
bull65634873bull__
bulla74620563bull_a
bullae83416163bullae
bulldog1174253bulldog
bulled94626493bulled
bullet84528613bullet
bullhorn1344463bullhorn
bulling104324793bulling
bullions101710043bullions
bullock1537193bullock
bullous9311663bullous
bullpen1135193bullpen
bulls75629573bull_s
bully105124813bull_y
bunion83111313bunion
burton8311273burton
button8310273button
callan83619603callan
callow114714663callow
carillon1046963carillon
cello74919583cello_
cellos84517803cellos
cion613330913ci__on
citron83112983citron
clon66232483__clon
collop107312313collop
colon78630193_colon
cotillon1045053cotillon
cullion91910233cullion
dalton7311273dalton
dialog837973dialog
diglot83014333diglot
dildo71911773dildo_
dildoe8198673dildoe
dildos8179303dildos
dill55239973dill__
dilled84122223dilled
dills65530973dill_s
dilly94923783dill_y
diploe9810153diploe
diplont10311693diplont
diuron738573diuron
doblon938013doblon
dollop9259363dollop
eidolon844913eidolon
eikon939463ei_kon
etalon648973etalon
falcon11310293falcon
fallen93813373fallen
fallow124713853fallow
felloe93513923felloe
fellow123712743fellow
felon84619293_felon
fill75540193fill__
fille84327403fill_e
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
filling113520803filling
fillip11268953fillip
fills84632373fill_s
filly114424903fill_y
filo76034283fi_lo_
filos86125383fi_los
follow124010353follow
galleon8278713galleon
gallons83015953gallons
galloon82910643galloon
gallop93311383gallop
gibbon1135323gibbon
gibson935123gibson
giglot84013133giglot
gill56336183gill__
gilled84521633gilled
giller74519733giller
gillie74816943gillie
gilling93520383gilling
gills64728193gill_s
gilly94321633gill_y
gipon84212413gi_pon
giron66118993gi_ron
gluon6311223_gluon
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halon86124863_halon
hellion10311133hellion
hello86522983hello_
hellos95321683hellos
hill76439493hill__
hilled104022223hilled
hiller94421633hiller
hilling113821773hilling
hilloas104413553hilloas
hillock1646693hillock
hilloed113211293hilloed
hilloes103815963hilloes
hilloing12158303hilloing
hills85431353hill_s
hilltop1244783hilltop
hilly114422163hill_y
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
icon66922043_i_con
igloo6410493_igloo
ikon85814953_i_kon
ill37437093_ill__
iller54821293_iller
ills47030423_ill_s
illy76925333_ill_y
inion54620183_inion
ion36051023_i__on
iron46728463_i_ron
jello126716273jello_
jellos134714283jellos
jill116430263jill__
jillions15178283jillions
jills125122823jill_s
kelson1038153kelson
kill85533183kill__
killed113918773killed
killer104917953killer
killie104114893killie
killing123118723killing
killjoy2142343killjoy
killock1255253killock
kills94526173kill_s
kiln85620983ki_l_n
kilo86028673ki_lo_
kilos95021473ki_los
kiloton1196313kiloton
lallan63414173lallan
lilo46731563li_lo_
lilos55821873li_los
lion46334443__lion
lollop8238783lollop
loon47344793__loon
maillot9312173maillot
mallow114014743mallow
mellow114112223mellow
melon73922083_melon
melton8311553melton
merlon83012353merlon
micron103714283micron
mignon937953mignon
mikron12318503mikron
milden94113153milden
mill66541483mill__
mille75029133mill_e
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
milline92519113milline
milling103223683milling
millions101712433millions
millpond1344143millpond
millrun944183millrun
mills75435053mill_s
milo65536103mi_lo_
milos75428013mi_los
minion83416243minion
mullen83714763mullen
mullion91911173mullion
nelson638423nelson
niello636603niello_
niellos736143niellos
nill45634303nill__
nilled73919453nilled
nilling83619563nilling
nills54926673nill_s
ninon55517383ni_non
niton55418283ni_ton
nylon82910513_nylon
oilcan837793oilcan
oilman839483oilman
oilmen848313oilmen
orlon5415003_orlon
pallor8313673pallor
papillon1244723papillon
pavillon1344053pavillon
pelon74423213_pelon
phylon14318033phylon
pigeon949413pigeon
pill65339463pill__
pillar8314023pillar
pillbox1843413pillbox
pilled94222753pilled
pilling103722563pilling
pillions101610923pillions
pillory12247453pillory
pillows122610123pillows
pillowy15316423pillowy
pills74130973pill_s
pilot77435063pi_lot
pinion83815893pinion
pinon76024533pi_non
pinyon11459763pinyon
pion67235293pi__on
piston83515923piston
piton76121583pi_ton
pleon74216383_pleon
pollen83416453pollen
pylon103614003_pylon
ribbon1036533ribbon
rill45140903rill__
rille55728733rill_e
rilled74525653rilled
rilles64725503rilles
rillet64828853rillet
rilling84023623rilling
rills55032713rill_s
sallow94315753sallow
salmon84614183salmon
salon55228553_salon
saloon64418023saloon
semillon1045343semillon
sigloi737743sigloi
siglos7311473siglos
silicon9117533silicon
silken104410853silken
sill45545153sill__
siller64026063siller
sills55135993sill_s
silly84527623sill_y
silo46037913si_lo_
silos56029433si_los
silvan92810153silvan
simlin8311733simlin
simoon858063simoon
siphon1138463siphon
sirloin747593sirloin
solion6616383solion
solon55026133_solon
stolon64112073stolon
sullen62914293sullen
talion6317713talion
tallol63612223tallol
tallow93714203tallow
talon55824113_talon
teflon937453teflon
telson6310293telson
tiglons837343tiglons
tigon63914443ti_gon
till45941203till__
tilled74722953tilled
tiller64222543tiller
tilling83522783tilling
tills54631713till_s
trillion847973trillion
vill75235073vill__
villa85321233vill_a
villae95615383villae
villain1038483villain
villas96117263villas
villein1036753villein
villi86517853vill_i
villose1038053villose
villous102810023villous
vills86429323vill_s
villus93611223villus
violin9311983violin
violone1037153violone
virion9310683virion
vision9311313vision
wallop113310293wallop
wallow123913513wallow
wigeon1037223wigeon
wilco1039443wilco_
will75737513will__
willed104722453willed
willer94021063willer
willet95124833willet
willie94116453willie
willing113821613willing
willows13299753willows
willowy16276353willowy
wills84528963will_s
willy115321913will_y
yellow12429883yellow
yill75628973yill__
yills83921553yill_s
zill135727613zill__
zillah1836563zillah
zillions17168073zillions
zills144020783zill_s
zircon1754953zircon

Search took 6 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.390458182.1
2DLD Change Limit1127165094.76623650.0
3Display Results5095090.1563262.8
 (SQL Overall)1786915095.31233639.1
 
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.