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

250 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
abulia8351250(None) 
abelia83114401abelia
aboulia966551aboulia
abulias93210691abulias
abulic106411421abulic
abasia8712952abasia
abelian92810642abelian
abelias93213562abelias
abolla8410192abolla
aboulias1065542aboulias
aboulic1156282aboulic
alula5317092alul_a
amusia839172amusia
anuria6313122anuria
aulic74420242a_ulic
bulla74620562_bulla
dulia61014982_dulia
obelia8329452obelia
tabuli839362tabuli_
tabulis938832tabulis
thulia936112thulia
aalii5316133a_alii
aba512850953ab___a
abaca95118043ab_aca
abaci94718843abaci_
abaka114313823ab_aka
abasias9711013abasias
abatis84317933abatis
abaxial1646183abaxial
abaya104413173ab_aya
abba810522653ab__ba
abele76323253abel_e
abeles84719393abeles
ability12311443ability
able66340533ab_l_e
abled86926833ab_led
abler75624313ab_ler
ables75935543ab_les
ablins8316193ab_lins
ablush1147223ablush
ably99725133ab_l_y
aboil72217543ab_oil
abolish12311503abolish
abollae936943abollae
aboma91114603ab_oma
abri65522213ab_ri_
abris75722603ab_ris
abrosia939273abrosia
abseil837183abseil
abuse77119563abu_se
abused95614273abused
abuser85413683abuser
abuses85119103abuses
abusing1049113abusing
abusive1245283abusive
abut66834953abu__t
abuts75417073abu_ts
abuttal954553abuttal
abuzz15517213abu_zz
acacia10311353acacia
acedia9310393acedia
acholia1239973acholia
aculei839793aculei
adularia945053adularia
adult63520653adul_t
adults7299953adults
aecia73819283a_ecia
aeolian738623aeolian
agria65517143a_gria
ahull84010313ahul_l
aioli5318313aioli_
aiolis6316843aiolis
ajuga1335883aju_ga
akela9311343akel_a
ala312463603a__l_a
alba68328333a__lba
albizia1864093albizia
albumin1145563albumin
alexia132910463alexia
alfa77624273a__lfa
alga57927603a__lga
alias55834603a__lias
alif76242143a__lif
alit46155693a__lit
aliya83713483a__liya
alluvia1045193alluvia
alma66333023a__lma
alodia71112453alodia
alulae6312743alulae
alular6311353alular
alumin8513543alumin
alumina9510053alumina
alumna857343alumna
amia66836903a__mia
amnia75918643a_mnia
ampulla1164303ampulla
amulet8419573amulet
amusias938583amusias
amylic13108713amylic
analgia898363analgia
anemia82613573anemia
anilin6417793anilin
annuli6459053annuli_
anopia83412393anopia
anoxia133510023anoxia
anurias7312253anurias
anuric8812113anuric
aphelia1249423aphelia
aporia8315863aporia
aqua132813963aqu__a
aquaria1638043aquaria
aria46245423a__ria
asyla839333asyl_a
ataxia13179593ataxia
atelic8313703atelic
atonia63816513atonia
atria56022343a_tria
audial7312993a_udial
audio62917103a_udio
audit62527883a_udit
auld54125363a_ul_d
aura45836253a_u_ra
auric74521743a_uric
auris55331533a_uris
auxin121411913a_uxin
avulse935843avulse
axilla13289573axilla
azalea1537003azalea
azuki1864803azuki_
azukis1963733azukis
baalim1038473baalim
babesia1146623babesia
babul96317713babul__
babuls105413643babul_s
bacula103112673bacul_a
bailie83818363bailie
balsa77920413_balsa
baulk114914333baul_k
baulks12429373baulks
baulky15446313baulky
belga8313233_belga
belie75630383_belie
blin67228173_b_lin
blip88322773_b_lip
bola66035563_bol_a
bubba84311803_bubba
build84413353_build
built74325923_built
bulb85626693_bul_b
bulbar1039583_bulbar
bulbil10389573_bulbil
bulbs96016933_bulbs
bulge86419873_bulge
bulgy115214103_bulgy
bulimia1145043_bulimia
bulk105426153_bul_k
bulks115920613_bulks
bulky146215573_bulky
bull65634873_bul_l
bullae83416163_bullae
bulls75629573_bulls
bully105124813_bully
bumelia1145263_bumelia
buna64730723_bu_na
bunya103810093_bunya
bura66139533_bu_ra
burial84117623_burial
burin75626063_burin
burka114617693_burka
burqa165013093_burqa
bursa74921523_bursa
cabala103516913cabal_a
camelia11510433camelia
canula8312963canul_a
caulis85320083caulis
cilia73016763_cilia
coulis84018763coulis
culpa93610963_culpa
curia74523773_curia
dahlia1035773dahlia
doula65717773doul_a
dulias71212743_dulias
eluvia936133eluvia
exuvia1644223exuvia
fabliau1244903fab_liau
fabular12288693fabular
fabulist1347673fabulist
facula112912233facul_a
famuli1136763famuli_
fibula11258053fibul_a
folia83618933_folia
gambusia1343573gambusia
ganglia946613ganglia
glia56423153__glia
hamuli1137063hamuli_
hula74923753_hul_a
ilia46026823__ilia
inulin6311733inulin
kabala124011553kabal_a
kabuki1143963kabuki_
kabukis1243193kabukis
labella988943labella
labia75219013lab__ia
lazuli1535363lazuli_
lazulis1634903lazulis
lobelia947213lobelia
macula103013673macul_a
maquila1844703maquila
milia72719573_milia
moulin8313283moulin
mulla74317113_mulla
nebula857333nebul_a
nubia7311233_nubia
obeli73711933obeli_
obelias9279033obelias
obia67923113ob__ia
oboli73712873oboli_
oculi72010793oculi_
pabular11259473pabular
pabulum1344473pabulum
pallia83015593pallia
papula103011113papul_a
paulin8312983paulin
peculia1147133peculia
public12238143public
pula65129373_pul_a
puli65527623_puli_
pulik113613303_pulik
pulis74225603_pulis
pyuria1136953pyuria
qabala17399193qabal_a
qualia1559563qualia
radula749313radul_a
ranula6311813ranul_a
realia6314593realia
sulfa8313923_sulfa
tabla73318363tab_l_a
tabouli945843tabouli_
taboulis1045043taboulis
tabular9279763tabular
telia55821143_telia
thulias1035743thulias
tubulin9116433tubulin
tulip71111693_tulip
ulna46317333__ulna
ulva75412693__ulva
uvula845153uvul_a
vulva11448803_vulva
yamulka1651773yamulka
yautia937253yautia

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 Filter1786911127160.393454684.5
2DLD Change Limit1127162506.04618643.1
3Display Results2502500.0763289.5
 (SQL Overall)1786912506.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.