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

176 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
mullion9191117(None) 
bullion91911031bullion
cullion91910231cullion
million91813141million
mullions101910351mullions
billion92212172billion
bullions101710042bullions
cullions10219222cullions
emulsion1045922emulsion
hellion10311132hellion
jillion14188932jillion
millions101712432millions
mullein9278562mullein
mullen83714762mull_en
mulligan1145152mulligan
mulling103819992mulling
mullioned1245732mullioned
mullite9313012mullite
multiton1087342multiton
munnion935862munnion
muslin8312212musli_n
pillion92011702pillion
pulsion938392pulsion
scullion1065632scullion
zillion16188772zillion
antlion7310293antlion
auction93412933auction
avulsion1153863avulsion
ballon84117493ball_on
balloon93711433balloon
billions102211793billions
billon83713833bill_on
bulldog1174253bulldog
bullhorn1344463bullhorn
bullied104514813bullied
bullier94116433bullier
bullies94121893bullies
bulling104324793bulling
bullish12511193bullish
bullpen1135193bullpen
bunion83111313bu_nion
cullied104012353cullied
cullies94419963cullies
culling103921303culling
cullis84115993culli_s
cushion1236403cushion
dulling93418273dulling
dullish1148743dullish
dunlin739723dunli_n
durion7510963du_rion
elusion72310953elusion
elution72913823elution
emulation11312393emulation
emulsions1145343emulsions
evulsion1155063evulsion
fluxion1735043fluxion
fulling114019703fulling
fusion939773fu_sion
galleon8278713galleon
galliot82214133galliot
gallon73715813gall_on
galloon82910643galloon
gullied93812063gullied
gullies84717313gullies
gulling94019563gulling
hellions11310023hellions
hulling113619013hulling
hullo84417453hull_o_
hulloa95011183hull_oa
hulloing12146703hulloing
hulloo94511733hull_oo
hulloos104010073hulloos
hullos94916293hull_os
impulsion1343793impulsion
jillions15178283jillions
lion46334443___lion
lulling83616803lulling
malign939853m_align
malison939693malison
malkin122913153malki_n
malling103623663malling
mallow114014743mall_ow
mansion9611543mansion
marlin84220903marli_n
maudlin1037163maudli_n
medallion1244073medallion
melilot9311083melilot
melling102822623melling
mellow114112223mell_ow
melon73922083m_el_on
melton8311553m_elton
mention9314373mention
merlin83916683merli_n
merlon83012353merl_on
millier93716703millier
millime112511403millime
milline92519113milline
milling103223683milling
milliohm1544443milliohm
millionth1444793millionth
millpond1344143millpond
millrun944183millrun
minion83416243m_inion
mirliton1044183mirliton
mission9312743mission
modillion1244203modillion
mollie83517103molli_e
mollies93420233mollies
mollify1555503mollify
morion86217733m_orion
morrion959003morrion
motion85217553m_otion
mouflon12104083moufl_on
moulin8313283mouli_n
mucin93116823mu_ci_n
muffin14298873muffi_n
muhlies1238933muhlies
muling93519883mu_ling
mulish11311903mu_lish
mull65128803mull___
mulla74317113mull__a
mullah113710733mull_ah
mullahs12388733mullahs
mullas84215933mull_as
mulled94721553mull_ed
mulleins10277053mulleins
mullens93611313mullens
muller83820353mull_er
mullers93217303mullers
mullet84126823mull_et
mullets93614783mullets
mulley114013453mull_ey
mulleys12299203mulleys
mulligans1244773mulligans
mullioning1344243mullioning
mullites10411643mullites
mullock1535713mullock
mulls75124153mull__s
multipion1346103multipion
multitone1187763multitone
munition1038763munition
munnions1035273munnions
muntin82915183munti_n
muon65722733mu___on
murein8311763murei_n
muslins9312213muslins
mutation101412883mutation
muton73817003mu__ton
mutton8510453mu_tton
myelin1138973myeli_n
nucleon945553nucleon
nullify1334713nullify
nulling83818063nulling
nullity1037363nullity
pillions101610923pillions
pulling103821073pulling
pullman1135403pullman
pulsions1037713pulsions
purlin83615863purli_n
purloin9107493purloin
ruction93611613ruction
scallion1046793scallion
scullions1154683scullions
solion6616383_solion
stallion837523stallion
suasion739363suasion
suction93713043suction
sullen62914293sull_en
sullied83714483sullied
sullies74122233sullies
talion6317713_talion
trillion847973trillion
tuition738823tuition
turion6313163tu_rion
union54519793_u_nion
zillions17168073zillions

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.406440125.6
2DLD Change Limit1340271765.67023637.9
3Display Results1761760.0632793.7
 (SQL Overall)1786911766.13929107.5
 
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.