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

489 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
ballots9411603(None) 
allots64019171_allots
ballets93719511ballets
ballons93916961ballons
ballot84624091ballot_
allods73615082_allods
allot54933872_allot_
allows94517682_allows
alloys94014562_alloys
bailors93212412bailors
bailouts1036612bailouts
balboas113710072balboas
ballads104212912ballads
ballast9313992ballast
ballasts1037932ballasts
ballers94421012ballers
ballet84733972ballet_
ballies93725742ballies
ballon84117492ballo_n
ballonets1146722ballonets
balloon93711432balloon
balloons103110522balloons
balloted1189042balloted
balloter1078892balloter
balloters1157672balloters
balls76236412ball__s
ballute938542ballute
ballutes1037522ballutes
barlows12259972barlows
bellows124313302bellows
billets94516152billets
billons93013362billons
billows123611292billows
blots75626172b__lots
brulots946222brulots
bullets93516392bullets
bullous9311662bullous
callets93821702callets
callous93516602callous
fallouts1137882fallouts
fallows133713972fallows
galiots82311322galiots
gallets83517402gallets
galliots9228682galliots
gallons83015952gallons
galloots9268962galloots
gallops103211652gallops
gallous82813952gallous
gallows113513512gallows
galoots82410792galoots
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallot95426782hallot_
halloth134111252halloth
hallows134417392hallows
harlots103413292harlots
maillots1037472maillots
mallets93318492mallets
mallows123714322mallows
pallets93919302pallets
pallors9314362pallors
reallots837992reallots
sallets73719652sallets
sallows103915552sallows
shallots11319502shallots
tallits73215992tallits
tallols73311362tallols
tallows103313742tallows
wallets103914832wallets
wallops123410412wallops
wallows133613532wallows
abbots1039283_abbots
ablauts936083ablauts
abvolts12104373abvolts
aglets73915683_aglets
alants67722023_alants
aldols7109713_aldols
alerts64418223_alerts
algors7312553_algors
allays94313743_allays
allees64521483_allees
alleys95113303_alleys
allies63827673_allies
allod64418383_allo_d
allow85420663_allo_w
alloy85519973_allo_y
alls46740923_all__s
allsorts844923_allsorts
allyls9437273_allyls
almost81014433_almost
aloes54933673_a_loes
altos55822953_alto_s
alts46639903_a_l_ts
argots74116033_argots
ascots85312513_ascots
azlons154110423_azlons
baals76122703baal__s
babools11319453babools
baboons113211083baboons
baboos103517013ba_boos
backlogs1746633backlogs
backouts1698643backouts
bacons104917583ba_cons
baguets1037483baguets
bahts105617803ba__hts
bailees93914383bailees
bailers94221353bailers
baileys12388933baileys
bailies94120203bailies
bailor83412603bailo_r
bailout9414133bailout
bails75933523bail__s
baits76630583ba__its
balas76937213ba_l_as
balases93815433balases
balata8614673ba_lata
balatas9311833balatas
balboa10389963balbo_a
balcony1435853balcony
baldest102313533baldest
baldies105317703baldies
balds85524643ba_l_ds
baleens938473baleens
balers85626933ba_lers
bales76250083ba_l_es
balkers134915723balkers
balks114926293ba_l_ks
ball66043323ball___
ballad94315323ball_ad
ballade104012563ballade
ballades114211643ballades
balled94926893ball_ed
baller83825203ball_er
balletic1248073balletic
balling104424763balling
ballista1045803ballista
ballonet10314503ballonet
ballonne1045243ballonne
ballonnes1145323ballonnes
balloting1238393balloting
ballpoints1442903ballpoints
ballroom1245023ballroom
ballrooms1344143ballrooms
ballsy11508873ball_sy
bally105530103ball__y
ballyhoos1743093ballyhoos
balms95723923ba_l_ms
bals66354043ba_l__s
balsams11579013balsams
balsas86417523ba_lsas
bamboos1348753bamboos
bancos104713893banco_s
bandits103814793bandits
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893banjo_s
bankits133410153bankits
bannets94013843bannets
barbets114915843barbets
barbuts11439843barbuts
barhops14288113barhops
barless94317003barless
barleys125011843barleys
barlow112911423barlo_w
barons85025383ba_rons
barrets94917103barrets
barrows123411683barrows
baryons121010473baryons
basalts9358963basalts
basions94213953basions
baskets135111833baskets
bassets96414823bassets
bassos85313703basso_s
basts75936933ba__sts
batboys1465833batboys
bathos116215633batho_s
batons85519423ba_tons
bats66962333ba___ts
batts76727563ba__tts
baulks12429373baul_ks
bawlers124412733bawlers
bawls105719323bawl__s
bayous11411153ba_yous
bazooms20285383bazooms
bazoos173212623ba_zoos
beclogs1237073beclogs
beknots1335083beknots
bellboys1544523bellboys
belles85325993bell_es
bellhops1544873bellhops
bellies94023723bellies
bellow114213353bello_w
bells76432163bell__s
bellworts1445373bellworts
belons84119413b_elons
belows114614183b_elows
belts75931163b_el_ts
besots86415453b_esots
bhoots11459913b_hoots
bibelots1295133bibelots
bigots95015133b_igots
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilbo_s
bilious9310933bilious
billers94720833billers
billet86029723billet_
billies93923503billies
billions102211793billions
billon83713833billo_n
billow114111223billo_w
billowy15366903billowy
bills75632863bill__s
blasts85116773b_lasts
blats75132503b__lats
blazons1836163blazons
bleats85518613b_leats
blets75324943b__lets
bloats85215763b_loats
blobs95620033b__lobs
blocs95219653b__locs
blogs85319233b__logs
bloods94614843b_loods
blooms104613173b_looms
bloops106611343b_loops
blot65842323b__lot_
blows105423833b__lows
bluets87215493b_luets
blunts84512893b_lunts
blurts84412643b_lurts
bollocks1636503bollocks
bollox1548743bollo_x
bolloxes1736833bolloxes
bolls75531313boll__s
bolos75531373b_olo_s
bolsons969483bolsons
bolts76232113b_ol_ts
boots75837973b__oots
bots66453953b___ots
bowpots1446023bowpots
brillos9369183brillo_s
brulot8912213brulot_
bugloss1035893bugloss
bulblets1255353bulblets
bulbous1138293bulbous
bullate93415073bullate
bullbats1255893bullbats
bulldogs1274243bulldogs
bullet84528613bullet_
bullies94121893bullies
bullions101710043bullions
bullock1537193bullock
bullocks1636293bullocks
bullpouts1343193bullpouts
bulls75629573bull__s
bullshots1443173bullshots
burbots1168673burbots
cablets114216343cablets
cahoots1238473cahoots
callans94518473callans
callants104112143callants
callas84526753call_as
callboys1585183callboys
callees94117783callees
callers94221963callers
callet84536763callet_
callose9313663callose
calloses10313393calloses
callow114714663callo_w
calls75634733call__s
callus85317073call_us
calos74431903ca_lo_s
camlets114314623camlets
caplets114914523caplets
carrots9714623carrots
cellos84517803cello_s
challot123613263challot_
challoth16316103challoth
cloots85113693_cloots
clots75627643__clots
collets93517903collets
collops112611753collops
coplots11511593coplots
cullets94015613cullets
dalles74222063dall_es
dallies84023193dallies
daltons8310403daltons
diglots9299503diglots
dollops10287963dollops
drylots1143743drylots
eaglets84111663eaglets
faggots1234863faggots
fagots1039963fa_gots
falcons1239123falcons
fallals103310193fallals
fallers103917993fallers
falloff1245953falloff
falloffs1343253falloffs
fallout10313503fallout
fallow124713853fallo_w
falls85727653fall__s
faults94513553faul_ts
felloes104114383felloes
fellows134212433fellows
fillets103414753fillets
fillos94415083fillo_s
follows13409923follows
fylfots1642423fylfots
galiot72322593galiot_
galipots1145213galipots
gallants93310373gallants
gallate83417123gallate
gallates92815523gallates
galleons9258443galleons
gallet73630853gallet_
galleta8399643galleta
galletas9308133galletas
galleys11369713galleys
gallies84122713gallies
galliot82214133galliot_
gallipots1243773gallipots
gallnuts943923gallnuts
gallon73715813gallo_n
galloon82910643galloon
galloons9289703galloons
galloot82814223galloot
gallop93311383gallo_p
galls64729323gall__s
gallus74313203gall_us
galoot72719163galoot_
galops94712623ga_lops
gaults74112783gaul_ts
gavots1038113ga_vots
giglots9367863giglots
gullets84013713gullets
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hallo__
halloa94918123hallo_a
halloed113314913halloed
halloo95118973hallo_o
hallow124818323hallo_w
halls85633783hall__s
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
halts85230103ha_l_ts
hamlets123211403hamlets
haplonts1345773haplonts
harlot94422803harlot_
haslets102510863haslets
haylofts1783033haylofts
helloes103717463helloes
hellos95321683hello_s
helots95217703_helots
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
jabots1538883ja_bots
jailors14328753jailors
jalops15329593ja_lops
jellos134714283jello_s
lallans74113533lallans
lalls55324133lall__s
lollops9227443lollops
loots55431423__loots
lots47652093___lots
maggots1136563maggots
magots9312363ma_gots
maillot9312173maillot_
mallees93315973mallees
mallet84433053mallet_
malleus92911313malleus
mallow114014743mallo_w
malls76233433mall__s
maloti8313213ma_loti
maltols939403maltols
malts76331753ma_l_ts
marmots11311513marmots
marplots1245633marplots
mascots113910343mascots
matelots1047533matelots
melilots1046553melilots
mellows123812233mellows
merlots92710123merlots
millets94216843millets
misallots1144533misallots
mullets93614783mullets
ocelots977233ocelots
paletots1047803paletots
palets85122313pa_lets
pallet84232653pallet_
pallor8313673pallo_r
palls74332563pall__s
parlors9312913parlors
parlous9414293parlous
parrots9312743parrots
pellets94014783pellets
pillows122610123pillows
pilots84018873_pilots
plots75025673__plots
preallots1144513preallots
pullets94015163pullets
pullouts1045223pullouts
rallies73823343rallies
rallyes10348553rallyes
reallot7312133reallot_
replots93412633replots
rillets74216153rillets
rollouts8136733rollouts
sabots8314703sa_bots
sailors73213723sailors
sallet63734543sallet_
sallies73227813sallies
sallow94315753sallo_w
sallowy13369343sallowy
salmons93713263salmons
salols64017873sa_lols
salons63823693sa_lons
saloons74415323saloons
saloops93510133saloops
salts55431883sa_l_ts
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salvo_s
samlets93813553samlets
sandlots938293sandlots
saults65816173saul_ts
sawlogs1135393sawlogs
scallops12297393scallops
sellouts837493sellouts
shallops13288323shallops
shallot103614133shallot_
shallows14388863shallows
slaloms9106543slaloms
slots54830533__slots
sublots92410913sublots
swallows14295893swallows
tablets94714383tablets
tailors73212393tailors
talcous939483talcous
talents7312013talents
talions7314113talions
talipots1045623talipots
tallboys1374623tallboys
tallest7317093tallest
tallies73624603tallies
tallis63319963tall_is
tallit63422733tallit_
tallith102913063tallith
talliths11377433talliths
tallol63612223tallo_l
tallow93714203tallo_w
tallowy13347633tallowy
talls55133433tall__s
talons64019443ta_lons
tarots66422993ta_rots
thallous1136523thallous
valets93715623va_lets
vallate103016563vallate
valleys13407483valleys
valors93413773va_lors
varlets10411573varlets
vaults94511673vaul_ts
villous102810023villous
walkouts1544253walkouts
wallahs13409473wallahs
wallas95719393wall_as
wallet93327093wallet_
wallies103320743wallies
wallop113310293wallo_p
wallow123913513wallo_w
walls85529383wall__s
walnuts1033843walnuts
willets104414323willets
willows13299753willows
yellows13329603yellows
zealots1636763zealots

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 Limit1340274895.93622578.7
3Display Results4894890.1732826.6
 (SQL Overall)1786914896.51527427.6
 
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.