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

133 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
munnion93586(None) 
munnions1035271munnions
bunion83111312bu_nion
mansion9611542mansion
mention9314372mention
minion83416242m_inion
mullion91911172mullion
munition1038762munition
muntin82915182munti_n
trunnion843272trunnion
union54519792_u_nion
amnion84812053_amnion
anion55028813__anion
auction93412933auction
bullion91911033bullion
bunions92210473bu_nions
bunnies94415003bunnies
cannon84514443cann_on
cullion91910233cullion
cunning104214623cunning
cushion1236403cushion
dungeon9134553dungeon
dunlin739723dunli_n
dunning93514473dunning
dunnite857333dunnite
durion7510963du_rion
emulsion1045923emulsion
fanion94514323_fanion
function1337843function
funnier103210173funnier
funnies104113603funnies
funnily1336373funnily
funning113813613funning
fusion939773fu_sion
gonion73612833_gonion
grunion835433grunion
guanin7610803guani_n
guenon736403guen_on
gunnen7338713gunn_en
gunnies83413123gunnies
gunning93413173gunning
hunnish1336163hunnish
inion54620183__inion
junction1736203junction
junior1386143ju_nior
lunation8311923lunation
manioc103914823m_anioc
mannan85413623mann_an
mannikin14215503mannikin
manning103616383manning
mannish121710693mannish
mannite9312903mannite
mannitol1044043mannitol
mansions1069793mansions
menazon1846053menazon
mentions10312893mentions
midnoon1044683midnoon
mignon937953mign_on
million91813143million
minions93314623m_inions
minnies93617363minnies
minnow1135583minn_ow
mission9312743mission
misunion1084943misunion
monaxon1644913monaxon
monition10311723monition
monsoon938493monsoon
monuron937463monuron
morion86217733m_orion
morrion959003morrion
motion85217553m_otion
mucin93116823mu_ci_n
muffin14298873muffi_n
mullions101910353mullions
multiton1087343multiton
mungo84916053mu_ngo_
mungos94311373mu_ngos
muni65824413mu_ni__
munis75022003mu_ni_s
munitions1138173munitions
munting103718773munting
muntins92715133muntins
muon65722733mu___on
muonic10410183muoni_c
muonium1146863muonium
murein8311763murei_n
muslin8312213musli_n
mutation101412883mutation
muton73817003mu__ton
mutton8510453mu_tton
ninon55517383__ninon
nonunion845583nonunion
nuncio837973nuncio_
nuncios937113nuncios
nunnation9126563nunnation
nunnish1035933nunnish
onion54320973__onion
opinion946793opinion
pennon8310643penn_on
pension9412203pension
pinion83815893_pinion
pulsion938393pulsion
punition1038373punition
punkin123611523punki_n
punnier93511263punnier
punning103414993punning
quinin152811953quini_n
rennin63914033renni_n
reunion737673reunion
ronion63315643_ronion
ruction93611613ruction
runnier74010113runnier
running83514593running
suasion739363suasion
suction93713043suction
sunnier73412153sunnier
sunnily1037833sunnily
sunning83715673sunning
tannin62613933tanni_n
tension7311803tension
ternion739493ternion
trunnions943003trunnions
tuition738823tuition
tunnies73614263tunnies
tunning83514453tunning
turion6313163tu_rion
turnon638193turn_on
unction9310663_unction
unions64216753_u_nions
unison649033_unison
unpin72613243_unpi_n
unwon84512343_u_nwon
wanion93213063_wanion

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.390458182.1
2DLD Change Limit1340271336.61020276.4
3Display Results1331330.0502660.0
 (SQL Overall)1786911337.05025346.2
 
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.