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

286 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
abolla841019(None) 
abollae936941abollae
abelia83114402abelia
aboil72217542aboil_
aboma91114602abo_ma
aboral8314372aboral
aboulia966552aboulia
abulia83512502abulia
apollo837182apollo
atoll57913922atoll_
atolls65511352atolls
axilla13289572axilla
bola66035562_bo_la
boll65634752_boll_
bolls75531312_bolls
boyla102912362_boyla
bulla74620562_bulla
cholla113911022cholla
holla84918492_holla
labella988942labella
olla44821172__olla
aba512850953ab___a
abaca95118043ab_aca
abaka114313823ab_aka
abasia8712953abasia
abaya104413173ab_aya
abba810522643ab__ba
abele76323253ab_ele
abeles84719393abeles
abelian92810643abelian
abelias93213563abelias
able66340533ab__le
abled86926833ab_led
abler75624313ab_ler
ables75935543ab_les
abloom1039783abloom
ably99725133ab__ly
abo59045963abo___
aboard9312613aboard
abode85518813abo_de
aboded104912513aboded
abodes94417513abodes
abohm1247973abo_hm
abohms1335003abohms
abolish12311503abolish
abomas101113583abomas
abomasa11114613abomasa
aboon74918703abo_on
aborally1347063aborally
abort76133583abo_rt
aborts84916183aborts
abos67734413abo__s
aboulias1065533aboulias
aboulic1156283aboulic
abound9239863abound
about75229083abo_ut
above105414323abo_ve
aboves114512843aboves
abrosia939273abrosia
absolve1244513absolve
abulias93210693abulias
abulic106411423abulic
abvolt11169833abvolt
abvolts12104373abvolts
acholia1239973acholia
acold86214923aco_ld
aeolian738623aeolian
afoul8510193afoul_
agonal7410053agonal
agora6914333ago_ra
ahold94714253aho_ld
aholds10469483aholds
ahull84010313ahull_
aioli5318313aio_li
aiolis6316843aiolis
akela9311343a_kela
ala312463603a___la
alba68328333a__lba
alfa77624273a__lfa
alga57927603a__lga
all36148233a__ll_
allay85620393a__llay
alls46740923a__lls
ally76935643a__lly
alma66333023a__lma
alodia71112453alodia
aloha8513613alo_ha
alula5317093a_lula
amboina1137953amboina
amboyna1443683amboyna
amoeba1035593amoeba
amole75724593amo_le
amoles84122193amoles
amoral8314623amoral
ampulla1164303ampulla
anally9513503anally
ancilla948603ancilla
anoa45634473ano__a
anodal72512113anodal
anole55330373ano_le
anoles64827423anoles
anopia83412393anopia
anoxia133510023anoxia
aorta55922573a_orta
apodal9289823apodal
apollos946793apollos
apolog938903apolog
aporia8315863aporia
areola6813673areola
argala74712663argala
armilla936993armilla
aroma71220143aro_ma
asyla839333a_syla
atonal6514023atonal
atonia63816513atonia
avellan1037293avellan
avowal1246323avowal
awol75620673awo_l_
awols84713523awo_ls
axillae14248233axillae
axillar14247563axillar
axillas14278963axillas
axonal1347653axonal
azalea1537003azalea
azole145118033azo_le
azoles154614613azoles
azonal1568273azonal
babool103012153babool_
babools11319453babools
bacula103112673bacula
ball66043323_ball_
ballad94315323_ballad
balls76236413_balls
bally105530103_bally
balsa77920413_balsa
barilla9310323barilla
belga8313233_belga
bell66237183_bell_
belle75827833_belle
bells76432163_bells
belly104625493_belly
bill67239933_bill_
bills75632863_bills
billy105525363_billy
boa56954033_bo__a
bogle85821683_bogle
bohea105013733_bohea
boil66335183_boil_
boils75427193_boils
bolar75123473_bolar
bolas74733763_bolas
bold75432813_bo_ld
boldly12399423_boldly
bolds85825283_bolds
bole66448693_bo_le
boles75448603_boles
bollard103210503_bollard
bolled94722653_bolled
bollix1538053_bollix
bollox1548743_bollox
bolo65535953_bo_lo
bolos75531373_bolos
bolt66254173_bo_lt
bolts76232113_bolts
bolus79125543_bolus
bora66141633_bo_ra
boral75831703_boral
bota66236503_bo_ta
boule74828043_boule
boulle84614613_boulle
bowl96827703_bowl_
bowls106121433_bowls
boylas113011723_boylas
brolly114510853brolly
bull65634873_bull_
bullae83416163_bullae
bulls75629573_bulls
bully105124813_bully
cabala103516913cab_ala
cabbala1367183cabbala
cabomba1544083cabomba
cabrilla1245833cabrilla
calla74827073_calla
canella9310793canella
canola8313623cano_la
cavalla1257883cavalla
cella75420313_cella
challa114014193challa
chola104718033cho_la
chollas123811353chollas
coala77521123_coala
cola66541393_co_la
collar83816173_collar
colly104926773_colly
colza165112983_colza
coolly114811393coolly
corolla938623corolla
dobla84913643_dobla
doll56632493_doll_
dollar74110983_dollar
dolls66126923_dolls
dolly96125203_dolly
dolma86214173_dolma
doula65717773_doula
droll65415403droll_
drolls75312393drolls
drolly105411673drolly
favella1336173favella
fella84918653_fella
flabella1344963flabella
folia83618933_folia
folly115022603_folly
gabelle10259213gabelle
glabella1144273glabella
golly95121103_golly
hollas94616903_hollas
hollo84822163_hollo
holloa94914823_holloa
holly114824433_holly
hoopla1147633hoopla
jolly154517513_jolly
kabala124011553kab_ala
kabbala1584613kabbala
knoll9389603knoll_
knolls10367413knolls
knolly13336133knolly
koala95112213_koala
kola85124963_ko_la
lamella988603lamella
latilla737953latilla
loll46128383_loll_
lolls512121733_lolls
lolly85120663_lolly
manilla93012473manilla
maxilla16248193maxilla
mola66035633_mo_la
molal75120343_molal
moll66735703_moll_
mollah11319453_mollah
molls75129783_molls
molly105222493_molly
moola75117033_moola
mulla74317113_mulla
obelia8329453obelia
obol65220613obo_l_
obole75917143obo_le
oboles83815833oboles
oboli73712873obo_li
obols73715863obo_ls
obolus8378813obolus
olea46532723__olea
ollas54218283__ollas
paella8410913paella
papilla11127913papilla
patella938953patella
payola11208113payo_la
polka11310413_polka
poll66332133_poll_
polls74627723_polls
psylla1133953psylla
qabala17399193qab_ala
quoll14379493quoll_
quolls15327303quolls
roll46331653_roll_
rolls55326233_rolls
rubella9146523rubella
scilla8310943scilla
sola45541863_so_la
stella63612973stella
tabla73318363tab__la
tabouli945843tabouli
tola45236333_to_la
toll45535263_toll_
tolls54728433_tolls
troll54416533troll_
trolls64613943trolls
trolly94012353trolly
vanilla10238743vanilla
villa85321233_villa
viola85915543vio_la
voila84813943_voila
volta85215623_volta
volva11399003_volva
walla85321033_walla
wholly15366573wholly
woolly12408513woolly

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.1401276364.3
2DLD Change Limit1127162865.75019602.8
3Display Results2862860.0763763.2
 (SQL Overall)1786912865.96629951.6
 
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.