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

480 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
battling11311049(None) 
bantling112611991bantling
batting104422271batt_ing
bottling11279141bottling
brattling1236001brattling
rattling92510871rattling
tattling9259461tattling
wattling12258781wattling
babbling12228692babbling
baffling1756052baffling
bailing103723522ba_iling
baiting103918882bait_ing
baling94829692ba__ling
balling104424762ba_lling
bantlings12216592bantlings
basting104227202bast_ing
batching163712092batching
bathing134816242ba_thing
batiking1537502batiking
bating95132252ba_t_ing
battening12268852battening
battering122715142battering
battings114010572batt_ings
batwing13509812ba_twing
bawling133813862ba_wling
beetling1139282beetling
betting103921402bett_ing
bitting103717292bitt_ing
blatting114111652blatt_ing
bottlings12215292bottlings
brittling1235542brittling
bustling112110062bustling
butling103516812b_utling
butting103519282butt_ing
castling11311232castling
catling104819792ca_tling
catting103922642catt_ing
cuttling1138202cuttling
dartling1039562dartling
embattling1542192embattling
fatling113815682fa_tling
fatting113818702fatt_ing
fettling1266772fettling
guttling1037292guttling
hatting113920232hatt_ing
kittling1336062kittling
mantling112012602mantling
matting103620142matt_ing
mottling11197752mottling
nettling957212nettling
patting103722342patt_ing
pettling1168212pettling
prattling1246302prattling
ratting83822362ratt_ing
rattlings10235512rattlings
settling978942settling
tatting84019522tatt_ing
twattling1332692twattling
vatting113614852vatt_ing
vittling1236142vittling
abating10413973abat_ing
abetting1158293abetting
abutting1137003abutting
acting95920983_act_ing
addling10229833_addling
ailing74331013_a_iling
ambling121411793_ambling
aneling82719503_aneling
angling92816043_angling
ankling122912063_ankling
anteing8312813_anteing
anting75827023_ant_ing
argling92812733_argling
atheling1249203_atheling
atoning83514873_atoning
attain6311753_attain_
attains7310983_attains
attaint7313473_attaint
attiring939483_attiring
attuning935903_attuning
autoing8314043_autoing
baaing94916163ba__aing
babblings13194373babblings
babying1537963ba_bying
baching156017753ba_ching
backing165523443ba_cking
baculine1238983baculine
badging123712793ba_dging
baffing164011603ba_ffing
bagging123316983ba_gging
baking135626623ba__king
balding114015063ba_lding
balking143717353ba_lking
balkline1437973balkline
bamming144611813ba_mming
banding114921413ba_nding
bandying15218073bandying
banging114019863ba_nging
baning95127833ba__ning
banking144621353ba_nking
banning103818233ba_nning
banteng1046363bant_eng
bantering122414233bantering
baptising1446093baptising
baptizing2345833baptizing
barbing123716993ba_rbing
barding113822893ba_rding
barfing134615093ba_rfing
barging114018483ba_rging
baring95135853ba__ring
barking144724183ba_rking
barning104320353ba_rning
barreling1238043barreling
barring104021593ba_rring
bartering122313643bartering
baseline10310753baseline
bashing135422583ba_shing
basing95427663ba__sing
basking144718613ba_sking
bastings114214693bast_ings
batfowling1942443batfowling
batlike133311883ba_tlike
battalia1045293battali_a
battalias1144803battalias
battalion1144083battalion
battalions1242893battalions
batten85217123batt_en_
battens95313263batt_ens
battier93515713batt_ier
battik1238093batt_i_k
battiks1337143batt_iks
battle85217863battl__e
battled104213123battl_ed
battler94113383battl_er
battlers104110973battlers
battles94517683battl_es
baulking1536003baulking
baying125222583ba__ying
beating104326873beat_ing
belittling1343193belittling
belling103825073b_elling
belting104119133belt_ing
beltline1036943beltline
berthing14209593berthing
besting104923923best_ing
betaking153010143betaking
betiding1239913betiding
bettering122212753bettering
beveling143011033beveling
billing103823853b_illing
birling104317053b_irling
birthing14338433birthing
bitching163610623bitching
bitewing1435293bitewing
biting95321823b_it_ing
bittering122511983bittering
bittings11339293bitt_ings
blasting114013423blast_ing
blattering13108713blattering
blitzing2035903blitzing
blotting113910433blotting
boasting113512493boast_ing
boating103721303boat_ing
bobbling12238643bobbling
boggling13257163boggling
boiling103819673b_oiling
bolling103820883b_olling
bolting104416763bolt_ing
boodling121910243boodling
booting103821363boot_ing
botching16359703botching
bottoming1444433bottoming
botulin947653botulin_
botulins1047063botulins
boweling143410683boweling
bowling133916493b_owling
brabbling1334963brabbling
brailing113514793brailing
brailling1247773brailling
brambling1635543brambling
brandling1348253brandling
bratticing1543923bratticing
brawling143210043brawling
bridling122610583bridling
brisling112410843brisling
bristling1246663bristling
broiling113112013broiling
bruting102612993brut_ing
bubbling12248223bubbling
buckling17259113buckling
bugling113615343b_ugling
bulling104324793b_ulling
bumbling15249763bumbling
bundling12219703bundling
bungling12269543bungling
bunting103718833bunt_ing
buntline10198063buntline
burbling13249423burbling
burgling12239303burgling
burling104421133b_urling
busting104221793bust_ing
bustline10208843bustline
buttering122312523buttering
buttoning1246463buttoning
byrling13337373b_yrling
cabling124017553ca_bling
cackling172610943cackling
cageling12310843cageling
cajoling18318423cajoling
calling103826773ca_lling
canaling112016403canaling
candling122313873candling
canting104725903cant_ing
carling103727063ca_rling
caroling113317003caroling
carting104228283cart_ing
casting104628343cast_ing
catching163712773catching
catering112019903catering
catlin83819073ca_tlin_
catlings113712043ca_tlings
catlins93818843ca_tlins
caviling14310113caviling
chatting142810143chatt_ing
chitling142910663chitling
cuittling1234103cuittling
cutting103817493cutt_ing
dabbling14227973dabbling
daddling12258233daddling
daggling12237063daggling
dandling112511733dandling
dangling112611233dangling
dappling1436843dappling
darkling1437483darkling
darling93418363da_rling
darting94020663dart_ing
dateline9810353dateline
dating85326483da_t_ing
dauting93814763daut_ing
dawdling14236373dawdling
dawting123610673dawt_ing
dazzling1834363dazzling
dittoing1036263dittoing
dotting93314483dott_ing
dratting10389653dratt_ing
eagling91113603ea_gling
eanling81416673ea_nling
earthing12310323earthing
earthling1346193earthling
easting84924303east_ing
eating75134403ea_t_ing
entitling1037103entitling
fabling133413623fa_bling
failing113521333fa_iling
faithing1537153faithing
falling113621583fa_lling
farthing1538073farthing
farting114120753fart_ing
fasting114522833fast_ing
fating105328673fa_t_ing
fatlings12359303fa_tlings
fattening13287833fattening
faulting12237733faulting
fetting113517873fett_ing
fettlings1353753fettlings
fitting113516563fitt_ing
flatling123410013flatling
flatting123511253flatt_ing
footling12239923footling
gabbling14238073gabbling
gabling113514543ga_bling
gaggling10217463gaggling
gaiting93716583gait_ing
galling93921963ga_lling
gambling14218963gambling
gangling112411403gangling
gantline9410903gantline
gaoling93314653ga_oling
garbling12249453garbling
gargling11239203gargling
gasting95022763gast_ing
gating84826953ga_t_ing
gaveling133410163gaveling
gentling1048453gentling
getting93316563gett_ing
gitting93215703gitt_ing
gutting93415923gutt_ing
hackling183310163hackling
hafting144014173haft_ing
haggling14227273haggling
hailing113820693ha_iling
haling104229783ha__ling
halting114419073halt_ing
handling132312713handling
hanting114124483hant_ing
hassling1236803hassling
hasting114725193hast_ing
hatching173312213hatching
hatchling1844953hatchling
hating104929713ha_t_ing
hauling113714433ha_uling
hitting113017273hitt_ing
hotting113116513hott_ing
hurtling12318313hurtling
hustling12228793hustling
hutting113016033hutt_ing
intitling1037213intitling
jailing153415843ja_iling
jangling17249623jangling
jetting153815343jett_ing
jettying1933953jettying
jostling16207123jostling
jotting152912773jott_ing
justling16207253justling
jutting153313713jutt_ing
juttying1933573juttying
karting123716063kart_ing
kitling123313573_kitling
kitting123214443kitt_ing
labeling11311643labeling
ladling92813393la_dling
lalling83519623la_lling
lasting84725243last_ing
latching143712023latching
latening9711493latening
lathing114315693la_thing
latticing1246063latticing
lattin64316223latt_in_
lattins74115483latt_ins
letting83218533lett_ing
lotting82917753lott_ing
mackling172710063mackling
maculing13219583maculing
mailing102923343ma_iling
malling103623663ma_lling
malting103219083malt_ing
mangling122312623mangling
mantlings12207223mantlings
marbling13179883marbling
marling103322763ma_rling
marting103325013mart_ing
masting104325823mast_ing
matching163512393matching
mating94832913ma_t_ing
mattering122314053mattering
mattin84416633matt_in_
mattings11369673matt_ings
mattins93316143matt_ins
maturing1139953maturing
mauling103315683ma_uling
metaling111613713metaling
naething1236073naething
nailing83419963na_iling
nattering102212203nattering
nestling958893nestling
netting84018763nett_ing
nutting83316233nutt_ing
paddling13218643paddling
paling93530133pa__ling
palling104024483pa_lling
paneling111013623paneling
panting104025423pant_ing
parling103823763pa_rling
paroling113316213paroling
parting103527383part_ing
partying14168893partying
pasting103826553past_ing
patching163212753patching
patining11312303patining
pattering122314423pattering
pestling111010253pestling
petting103720953pett_ing
pitting103618873pitt_ing
platting114813033platt_ing
potting103720893pott_ing
putting103218573putt_ing
puttying1434953puttying
rabbling13239333rabbling
raddling11229773raddling
raffling1567063raffling
rafting113815753raft_ing
railing83325643ra_iling
rambling131810773rambling
rankling132610113rankling
ranting84025413rant_ing
rassling939013rassling
rating74938703ra_t_ing
ratlin64116523ra_tlin_
ratline74517803ra_tline
ratlins73615583ra_tlins
rattening10288763rattening
rattlingly1443633rattlingly
raveling123414373raveling
rebottling1343733rebottling
retiling93319483retiling
retitling1039773retitling
retting83425883rett_ing
rootling9269953rootling
rotting82919683rott_ing
rustling9249983rustling
rutting82718043rutt_ing
saddling11239593saddling
sailing83927373sa_iling
salting84120793salt_ing
sampling13510643sampling
sandling102214413sandling
sapling103217863sa_pling
sating74735453sa_t_ing
sauteing937913sauteing
scantling12107233scantling
scatting113311813scatt_ing
scuttling1234243scuttling
setting83621393sett_ing
settlings1054683settlings
shuttling1334283shuttling
sitting83519633sitt_ing
slatting94014233slatt_ing
spatting113111763spatt_ing
sprattling1363053sprattling
stabling112913653stabling
staling83925423_staling
stalling95116693stalling
stapling112813153stapling
starling93017123starling
startling1037373startling
stating83725163stat_ing
styling112910653_styling
swatting12309593swatt_ing
tabling103216033ta_bling
tackling153211123tackling
tailing82923103ta_iling
tangling101712533tangling
tarting84222653tart_ing
tasting84624213tast_ing
tattering102212323tattering
tattings9408823tatt_ings
tattooing1043963tattooing
tauting83316383taut_ing
tiling73426553__tiling
titling83715793_titling
toling73926123__toling
tootling9279523tootling
totaling9610293totaling
totting82816843tott_ing
turtling9238833turtling
tutting83515913tutt_ing
unbottling1343133unbottling
vailing113817943va_iling
vaulting12227223vaulting
vetting114216563vett_ing
wabbling16207743wabbling
waddling14237933waddling
waffling1845423waffling
wafting143911663waft_ing
waggling14197063waggling
wailing113620903wa_iling
waiting113618953wait_ing
waling104525303wa__ling
walling113520973wa_lling
waltzing2134263waltzing
wambling16198443wambling
wangling132310993wangling
wanting114220173want_ing
warbling14198943warbling
warsling12198593warsling
warstling1335063warstling
wasting114422843wast_ing
watching173011173watching
watering122316313watering
wauling112713113wa_uling
wawling143810963wa_wling
wetting114117383wett_ing
whittling1634383whittling
wintling12249923wintling
witling113215813_witling
witting113417063witt_ing
wotting112913843wott_ing
wrastling1335523wrastling
yattering132410443yattering
yawling14369183ya_wling

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461624808.14017956.0
3Display Results4804800.2032364.5
 (SQL Overall)1786914808.51620983.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.