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

118 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
acromia113996(None) 
acromial1248461acromial
abrosia939272abrosia
acholia1239972acholia
achromic1747612achromic
acrasia9310032acrasia
acromion1246062acromion
acronic112814692acronic
acrotic112515532acrotic
aerobia939462aerobia
aroma71220142a_rom_a
abdomina1343963abdomina
aboma91114603a_bom_a
abrosias1049033abrosias
acacia10311353ac_acia
academia1345113academia
acapnia1145913acapnia
acaroid103512313acaro_id
accidia1246993accidia
acedia9310393ac_edia
acequia1844133acequia
acerola947823acero_la
acholias1349573acholias
achromat15410103achromat
acidemia1344783acidemia
acmic11312333ac__mic
acrasias1048893acrasias
acrasin9311223acrasin
acrid86920103acr__id
acrobat11411813acrobat
acrogen1038193acrogen
acrolein1045843acrolein
acrolith1348453acrolith
acronical1347833acronical
acronym1445673acronym
acronymic1885003acronymic
across8312643acro_ss
acrostic1239943acrostic
acrotism1248213acrotism
acrylic1496283acrylic
actinia91710853actinia
adroit7518793adro_it
aerobic11310213aerobic
agnomina1144263agnomina
agnosia837643agnosia
agria65517143agr__ia
allodia8128793allodia
alodia71112453a_lodia
ambrosia1245543ambrosia
amia66836903a___mia
ammonia1148693ammonia
anaemia959803anaemia
anemia82613573a_nemia
anomic102516303a_nomic
anomie83215963a_nomie
anopia83412393a_nopia
anosmia946643anosmia
anoxia133510023a_noxia
aphonia122711883aphonia
aporia8315863a_poria
apraxia1646893apraxia
aprotic112715233aprotic
aramid93315613a_ramid
arcadia1039703arcadia
aria46245423a_r__ia
aroid65428343a_ro_id
aromas81018613a_romas
arroba898663arro_ba
asrama839193asram_a
atomic104115603a_tomic
atonia63816513a_tonia
atresia7310223atresia
atria56022343atr__ia
atrophia1348103atrophia
atropin9311583atropin
aurora6411763auro_ra
bromic122412693_bromic
bromid112612893_bromid
bromin102615693_bromin
cabomba1544083cabomba
caeoma1039033caeom_a
caramba1336893caramba
cardia9916373car_dia
caroli85918233caroli_
carom95025563carom__
caromed123713623caromed
caroming133312963caroming
caroms105619573carom_s
carotid102014823carotid
carotin92216723carotin
cecropia1455153cecropia
chroma132912473chrom_a
chromic1639853chromic
cobia94117513_c_obia
coma87134853_c_om_a
comic114721813_c_omic
comix163513203_c_omix
comma114514793_c_omma
coremia11310363coremia
coria75828323_c_oria
crania82418433_crania
croci95818133_croci_
crojik1934113_crojik
ectopia1147693ectopia
encomia1147983encomia
meropia1149613meropia
narcoma1145823narcom_a
parosmia1245953parosmia
sacraria1047393sacraria
sapremia1245203sapremia
sarcoma1147403sarcom_a
scholia1237823scholia
scoria8513493sc_oria
scotia8310793sc_otia
scrota8310183scro_ta
stroma84313073strom_a
uremia82910893_uremia
viremia1246083viremia

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.1531167915.0
2DLD Change Limit1340271187.12618808.2
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.32524394.7
 
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.