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

113 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
acholia123997(None) 
acholias1349571acholias
scholia1237831scholia
acromia1139962acromia
aphelia1249422aphelia
aphonia122711882aphonia
chola104718032_chol_a
cholla113911022_cholla
abelia83114403a_belia
abolla8410193a_bolla
aboulia966553aboulia
abrosia939273abrosia
abulia83512503a_bulia
acacia10311353ac_acia
acapnia1145913acapnia
accidia1246993accidia
acedia9310393ac_edia
acequia1844133acequia
acerola947823acerol_a
achalasia1444553achalasia
achenial1348283achenial
achillea1344103achillea
achoo10315083acho__o
achromic1747613achromic
acold86214933ac_ol_d
acrasia9310033acrasia
acrolein1045853acrolein
acrolith1348453acrolith
acromial1248463acromial
acronic112814693acronic
acrotic112515543acrotic
acrylic1496283acrylic
actinia91710853actinia
acyclic1345573acyclic
acyloin1247463acyloin
aeolian738623a_eolian
aerobia939463aerobia
agnosia837643agnosia
ahold94714253a_hol_d
aholds10469483a_holds
aioli5318313a_ioli_
aiolis6316843a_iolis
alcoholic1663713alcoholic
allodia8128793allodia
alodia71112453a_lodia
ammonia1148693ammonia
anopia83412393a_nopia
anoxia133510023a_noxia
anthelia1149113anthelia
anthodia1247803anthodia
aphagia13247663aphagia
aphasia122510873aphasia
aphelian1376963aphelian
aphonias132611143aphonias
aphonic142713393aphonic
aphotic142913123aphotic
aporia8315863a_poria
areola6813673areol_a
atonia63816513a_tonia
cachexia2263583cachexia
camelia11510433camelia
canola8313623canol_a
caroli85918233caroli_
catholic15158383catholic
challa114014193_challa
chela103916803_chel_a
chia96026623_ch__ia
chili106218483_chili_
chiliad1337563_chiliad
chilis115517873_chilis
choana1138443_choana
choir105313603_cho_ir
cholas114818003_cholas
choler113717153_choler
cholera12409093_cholera
choline122915383_choline
chollas123811353_chollas
cholo105217973_chol_o
cholos114716853_cholos
chopin132712193_chopin
chorea115216093_chorea
chorial124214143_chorial
choric133515903_choric
cilia73016763_c_ilia
cobia94117513_c_obia
cola66541393_c_ol_a
colic95726173_c_olic
colin76231693_c_olin
colza165112983_c_olza
coolie83821603_coolie
coria75828323_c_oria
dahlia1035773dah_lia
ecbolic1345623ecbolic
echoic1339043echo_ic
echolalia1463533echolalia
ectopia1147693ectopia
folia83618933__folia
holla84918493__holla
magnolia1144793magnolia
mahonia1238443mahonia
pachalic1757273pachalic
pachouli1553623pachouli_
pachoulis1643613pachoulis
parhelia1346713parhelia
phobia13278603_phobia
rachilla1345713rachilla
scholar1236953scholar
scholiast1446303scholiast
scholium1545643scholium
scoria8513503sc_oria
scotia8310803sc_otia
thoria93012893_thoria
thulia936113_thulia

Search took 8 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.453394461.4
2DLD Change Limit1340271136.89019452.4
3Display Results1131130.0303766.7
 (SQL Overall)1786911137.37324235.9
 
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.