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 “mahonia” 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
mahonia123844(None) 
mahonias1348061mahonias
ammonia1148692ammonia
aphonia122711882aphonia
atonia63816512_atonia
madonna1044402madonna
mania75634152ma__nia
masonic1139912masonic
valonia1048302valonia
acholia1239973acholia
adonis7314063_adonis
aeonian738353_aeonian
aeonic83517043_aeonic
agonic93515143_agonic
alodia71112453_alodia
amazonian2053113amazonian
amboina1137963amboina
ammoniac1455743ammoniac
ammonias1247953ammonias
ammonic1349163ammonic
amnia75918643_a_mnia
anopia83412393_anopia
anoxia133510023_anoxia
aphonias132611143aphonias
aphonic142713393aphonic
aporia8315863_aporia
atonias73315993_atonias
atonic83420473_atonic
axonic154312723_axonic
azonic175513153_azonic
baronial1049483baronial
bauhinia1343293bauhinia
begonia1047213begonia
canonic11312933canonic
dahlia1035773dah_lia
daphnia1345053daphnia
favonian1442973favonian
gazania1746123gazania
gonia64117533__gonia
honda9414983__honda
japonica19114033japonica
kahuna1394103kahun_a
kaonic1238763ka_onic
laconic1139883laconic
macchia1645893macchia
macon94519953macon__
macons104017243macon_s
madonnas1143843madonnas
madrona10288703madron_a
maffia14327203ma_ffia
mafia104418033ma__fia
magenta1038623magenta
magnolia1144793magnolia
mahatma1443783mahatma
mahjong2042273mahjon_g
mahjongg224703mahjongg
mahjongs2141813mahjongs
mahoe10315573maho__e
mahoes11313103maho_es
mahout11415803maho_ut
mahouts1237143mahouts
mahzorim2442543mahzorim
maiolica1244483maiolica
majolica1942843majolica
malanga1036663malanga
malaria9313693malaria
maloti8313213maloti_
mana65341963ma__n_a
manana84816073manan_a
manga85026203ma__nga
maniac103917973ma__niac
manias84029033ma__nias
manic94629443ma__nic
manila84518303ma__nila
manna75522543ma__nna
manorial10311083manorial
manta75629913ma__nta
maranta9311693maranta
maria75032883ma__ria
marina84623413marin_a
mason74820183mason__
masoned1039803masoned
masoning1139763masoning
masonite1049683masonite
masonry1244123masonry
masons83916513mason_s
melodia1038883melodia
meropia1149613meropia
mesonic11310093mesonic
monie75631653m__onie
moronic11311863moronic
muonic10410183m_uonic
myopia13318443m_yopia
myotonia1346273myotonia
oogonia846483oogonia
phobia13278603_phobia
phonic133315213_phonic
pogonia1048933pogonia
ramona8412413ramon_a
saponin9310263saponin
scholia1237833scholia
sthenia1058503sthenia
syconia1248313syconia
taenia6313193ta_enia
tahini939893tahini_
tahinis1048013tahinis
thoria93012893_thoria
tithonia1195613tithonia
valonias1147473valonias
wahconda1741633wahconda

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271106.04622167.9
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.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.