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

229 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
millions10171243(None) 
billions102211791billions
jillions15178281jillions
million91813141million_
mullions101910351mullions
pillions101610921pillions
zillions17168071zillions
billion92212172billion_
billons93013362bill_ons
bullions101710042bullions
cullions10219222cullions
hellions11310022hellions
jillion14188932jillion_
milliers102611902milliers
millimes122411372millimes
milline92519112milli_ne
millines102718062millines
milling103223682milli_ng
millings113712582millings
milliohm1544442milliohm
milliohms1643672milliohms
millionth1444792millionth
millionths1543242millionths
millpond1344142millpond
millponds1443502millponds
millruns1043642millruns
minions93314622mi_nions
mirlitons1144112mirlitons
missions10311902missions
modillions1343682modillions
mullion91911172mullion_
pillion92011702pillion_
trillions947182trillions
zillion16188772zillion_
aiblins9311473aibli_ns
ailerons849853ailerons
antlions839193antlions
ballons93916963ball_ons
balloons103110523balloons
bazillions2143093bazillions
bilious9310933bi_lious
billies93923503billi_es
billing103823853billi_ng
billings113412633billings
billionth1444163billionth
billionths1553043billionths
billon83713833bill_on_
billows123611293bill_ows
bullion91911033bullion_
collins93419833colli_ns
cotillions1244783cotillions
cullion91910233cullion_
decillions1345433decillions
dictions111812673dictions
dilations102614453dilations
dillies84122163dilli_es
dilutions10248583dilutions
diluvions13224443diluvions
dislimns1144813dislimns
elisions82210423elisions
emissions1146923emissions
emulsions1145343emulsions
fictions132410743fictions
fillies103420253filli_es
filling113520803filli_ng
fillings122910503fillings
fillips12298133filli_ps
fillos94415083fill_o_s
fissions1138033fissions
galleons9258443galleons
galliots9228683galliots
gallons83015953gall_ons
galloons9289703galloons
gazillions2042703gazillions
gillies84120963gilli_es
gilling93520383gilli_ng
hellion10311133hellion_
hilling113821773hilli_ng
hilloas104413553hill_oas
hilloes103815963hill_oes
hilloing12158303hilloing
hillos94618893hill_o_s
hilltops1344933hilltops
illations9311393_illations
illites72415013_illites
illusions946213_illusions
inions64417003_i_nions
kazillions2352513kazillions
killicks1354873killicks
killies113318113killi_es
killing123118723killi_ng
killings133710483killings
killjoys2242033killjoys
kilotons1286313kilotons
lions55923213___lions
maillots1037473maill_ots
maligns1038133m_aligns
malisons1048783malisons
malkins133311803malki_ns
malling103623663malli_ng
mallings113413093mallings
mallows123714323mall_ows
mansions1069793mansions
marlins93420473marli_ns
medallions1343263medallions
melilots1046553melilots
melling102822623melli_ng
mellows123812233mell_ows
melons84117713m_el_ons
meltons9410923m_eltons
mentions10312893mentions
merlins93015813merli_ns
merlons93311273merl_ons
microns113814783mi_crons
midirons1145883midirons
midline102315103midli_ne
midlines112613333midlines
midlists1137523midlists
midlives14287463midlives
midnoons1144403midnoons
mignons1037863mi_gnons
mikrons13428413mi_krons
mildens10339933mi_ldens
milding113615453mildi_ng
milfoils1343893milfoils
milieus939803mi_lieus
milking143712763milki_ng
milksops1642853milksops
millages113212903millages
milldams1344633milldams
millers93621343mill_ers
milles84526563mill__es
millets94216843mill_ets
millhouse1443903millhouse
milliard1147033milliard
milliards1246193milliards
milliare1039153milliare
milliares1149403milliares
milliary1346853milliary
millibar1275353millibar
millibars1365563millibars
millieme12276803millieme
milliemes13255843milliemes
millier93716703milli_er
milligal1145703milligal
milligals1245033milligals
millilux1742933millilux
millime112511403milli_me
millimho1543473millimho
millimhos1642893millimhos
millimole1344343millimole
millimoles1444263millimoles
milliner102811863milliner
milliners11289953milliners
milliped1337383milliped
millipeds1444703millipeds
millirem1245693millirem
millirems1344323millirems
millivolt1444363millivolt
millivolts1552433millivolts
millrun944183millrun_
mills75435053mill___s
millstone1145423millstone
millstones1245353millstones
millwork1745523millwork
millworks1845093millworks
milos75428013mi_l_o_s
milting103619123milti_ng
minion83416243mi_nion_
mirins83918903mi_ri_ns
mirliton1044183mirliton_
misaligns1244773misaligns
miscoins12311083miscoins
misjoins1736913misjoins
mislies92922283misli_es
mislikes143311833mislikes
mislives132912153mislives
mission9312743mission_
misunions1154533misunions
modillion1244203modillion_
mollies93420233molli_es
morions94014643m_orions
morrions1077673morrions
motions94215003m_otions
moulins9312703mouli_ns
mulleins10277053mulleins
mullens93611313mull_ens
mulligans1244773mulligans
mulling103819993mulli_ng
mullioned1245733mullioned
mullites10411643mullites
munnions1035273munnions
muslins9312213musli_ns
myelins1237353myeli_ns
nilling83619563nilli_ng
nonillions1045263nonillions
octillions1243613octillions
omissions1146153omissions
pilling103722563pilli_ng
pillows122610123pill_ows
pinions93413603pi_nions
pulsions1037713pulsions
rilling84023623rilli_ng
scallions1145783scallions
scullions1154683scullions
semillons1145093semill_ons
silicons10107163silicons
sillies73425083silli_es
simlins9311843simli_ns
sirloins836723sirloins
solions7513753_solions
stallions946073stallions
talions7314113_talions
tiglons837343tigl_ons
tilling83522783tilli_ng
tillites8312833tillites
trillion847973trillion_
vermillions1652723vermillions
vibrions1345093vibrions
villains1138013villains
villeins1136043villeins
villous102810023vill_ous
violins10311453violi_ns
virions1039873vi_rions
visions10311023vi_sions
willies103920153willi_es
willing113821613willi_ng
willows13299753will_ows
zillionth2152703zillionth

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622297.12320519.7
3Display Results2292290.0932462.4
 (SQL Overall)1786912297.63923391.9
 
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.