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

110 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
abrosia93927(None) 
abrosias1049031abrosias
ambrosia1245541ambrosia
abasia8712952ab_asia
abiosis939372abiosis
acrasia9310032acrasia
acromia1139962acromia
aerobia939462aerobia
agnosia837642agnosia
ambrosial1344032ambrosial
ambrosian1343712ambrosian
ambrosias1345332ambrosias
atresia7310222atresia
abasias9711013ab_asias
abdomina1343963abdomina
abelia83114403ab_elia
abioses9311493abioses
abiotic11510463abiotic
aboil72217543ab_o_il
abolla8410193ab_olla
aboma91114603ab_o_ma
abos67734413ab_os__
aboulia966553aboulia
abrachia1545843abrachia
abrasion1046623abrasion
abrasive1345753abrasive
abri65522213abr__i_
abris75722603abr__is
abroach1446213abroach
abroad9310943abro_ad
abulia83512503ab_ulia
acholia1239973acholia
acrasias1048893acrasias
acrasin9311223acrasin
acromial1248463acromial
acronic112814693acronic
across8312643acros_s
acrostic1239943acrostic
acrotic112515543acrotic
adroit7518793adro_it
aerobic11310213aerobic
aerosat7417183aerosat
aerosol747683aerosol
aerostat8410683aerostat
aftosa996573aftos_a
agnosias947243agnosias
agria65517143agr__ia
allodia8128793allodia
alodia71112453a_lodia
ambroid1238883ambro_id
ammonia1148693ammonia
amnesia938293amnesia
amusia839173a_musia
anoopsia1044363anoopsia
anopia83412393a_nopia
anopsia9258443anopsia
anosmia946643a_nosmia
anoxia133510023a_noxia
aphasia122510873aphasia
aphonia122711883aphonia
aplasia92510803aplasia
aporia8315863a_poria
apraxia1646893apraxia
aprotic112715243aprotic
aria46245423a_r__ia
ariosi64313033ariosi_
arista6415293a_rista
arkosic1346063arkosic
aroid65428343a_ro_id
aroma71220143a_ro_ma
arose55832083a_ros_e
arroba898663arro_ba
arsis55722423a_r_sis
astasia7310933astasia
atonia63816513a_tonia
atresias839473atresias
atresic9310003atresic
atria56022343atr__ia
atrophia1348103atrophia
atropin9311583atropin
aubretia1045263aubretia
aurora6411763auro_ra
babesia1146623babesia
banksia1335943banksia
barista9310813barista
baronial1049483baronial
brasil8713863_brasil
broil74918223_bro_il
bromic122412693_bromic
bromid112612893_bromid
bromin102615693_bromin
bros65635663_bros__
brose75227033_bros_e
broses86524403_broses
brosy106115383_bros_y
cabresta1243993cabresta
celosia939463celosia
fibrosis1345453fibrosis
labroid1038823labro_id
labrusca1241913labrusca
meropia1149613meropia
parosmia1245953parosmia
prosit85124593_prosit
pyrosis12411653pyrosis
rosin55325313__rosin
serosa6313023seros_a
sorosis72611973sorosis
tarsia65514273tar_sia
virosis1039023virosis
xerosis14249663xerosis

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.436409841.7
2DLD Change Limit1340271107.12618808.2
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.60823487.3
 
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.