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

239 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
million9181314(None) 
billion92212171billion
jillion14188931jillion
millions101712431millions
mullion91911171mullion
pillion92011701pillion
zillion16188771zillion
billions102211792billions
billon83713832bill_on
bullion91911032bullion
cullion91910232cullion
hellion10311132hellion
jillions15178282jillions
millier93716702millier
millime112511402millime
milline92519112milline
milling103223682milling
milliohm1544442milliohm
millionth1444802millionth
millpond1344142millpond
millrun944182millrun
minion83416242mi_nion
mirliton1044182mirliton
mission9312742mission
modillion1244202modillion
mullions101910352mullions
pillions101610922pillions
trillion847972trillion
zillions17168072zillions
aileron739833aileron
antlion7310293antlion
ballon84117493ball_on
balloon93711433balloon
bazillion2043273bazillion
billie85019173billi_e
billies93923503billies
billing103823853billing
billionth1444163billionth
billons93013363bill_ons
billow114111223bill_ow
bullions101710043bullions
cotillion1145283cotillion
cullions10219223cullions
decillion1245833decillion
diction102313053diction
dilation92215463dilation
dillies84122163dillies
dilution9239143dilution
diluvion12215423diluvion
dislimn1056103dislimn
elision72311103elision
emission1047673emission
emulsion1045923emulsion
fiction122010733fiction
fillies103420253fillies
filling113520803filling
fillip11268953filli_p
fillips12298133fillips
fillo84319783fill_o_
fillos94415083fill_os
fission1038733fission
galleon8278713galleon
galliot82214133galliot
gallon73715813gall_on
galloon82910643galloon
gazillion1942803gazillion
gillie74816943gilli_e
gillied95512313gillied
gillies84120963gillies
gilling93520383gilling
hellions11310023hellions
hillier103413963hillier
hilling113821773hilling
hillo84721653hill_o_
hilloa94713033hill_oa
hilloing12158303hilloing
hillos94618893hill_os
hilltop1244783hilltop
illation8311943_illation
illite63414923_illite
illusion846573_illusion
inion54620183_i_nion
kazillion2242573kazillion
killick1295313killick
killie104114893killi_e
killies113318113killies
killing123118723killing
killjoy2142343killjoy
kiloton1196313kiloton
lion46334443___lion
maillot9312173maill_ot
malign939853m_align
malison939693malison
malkin122913153malki_n
malling103623663malling
mallow114014743mall_ow
mansion9611543mansion
marlin84220913marli_n
medallion1244073medallion
melilot9311083melilot
melling102822633melling
mellow114112223mell_ow
melon73922083m_el_on
melton8311553m_elton
mention9314373mention
merlin83916683merli_n
merlon83012353merl_on
micron103714283mi_cron
midiron1046003midiron
midlife13248303midlife
midline102315103midline
midlist10312513midlist
midnoon1044683midnoon
mignon937953mi_gnon
mikron12318503mi_kron
milden94113153mi_lden
milding113615453milding
milesian1046473milesian
milfoil1264383milfoil
milia72719573mi_li_a
milieu8314113mi_lieu
milium104712683mi_lium
milkier133411163milkier
milkily16216553milkily
milking143712763milking
milkman1544913milkman
milkmen1565213milkmen
milksop1542833milksop
mill66541483mill___
millage103112753millage
milldam1245473milldam
mille75029133mill__e
milled94326173mill_ed
miller84625413mill_er
millers93621343millers
milles84526563mill_es
millet84030743mill_et
millets94216843millets
milliard1147033milliard
milliare1039153milliare
milliary1346853milliary
millibar1275363millibar
millieme12276803millieme
milliers102611903milliers
milligal1145703milligal
millilux1742933millilux
millimes122411373millimes
millimho1543473millimho
millimhos1642893millimhos
millimole1344343millimole
milliner102811863milliner
millines102718063millines
millings113712583millings
milliohms1643673milliohms
millionths1543243millionths
milliped1337383milliped
millirem1245693millirem
millivolt1444363millivolt
millponds1443503millponds
millruns1043643millruns
mills75435053mill__s
millstone1145423millstone
millwork1745523millwork
milo65536103mi_l_o_
milos75428013mi_l_os
miltier93214963miltier
milting103619123milting
minions93314623mi_nions
mirin75023153mi_ri_n
mirlitons1144113mirlitons
misalign1146433misalign
miscoin11311433miscoin
misjoin1637693misjoin
mislain9311243mislain
mislie83219153misli_e
mislies92922283mislies
mislike132914833mislike
mislit83019693misli_t
mislive122812693mislive
missions10311903missions
misunion1084943misunion
modillions1343683modillions
mollie83517103molli_e
mollies93420233mollies
mollify1555503mollify
morion86217733m_orion
morrion959003morrion
motion85217553m_otion
moulin8313283mouli_n
mullein9278563mullein
mullen83714763mull_en
mulligan1145163mulligan
mulling103819993mulling
mullioned1245733mullioned
mullite9313013mullite
multiton1087343multiton
munnion935863munnion
muslin8312213musli_n
myelin1138973myeli_n
nilling83619563nilling
nonillion945463nonillion
octillion1144173octillion
omission1046533omission
pillbox1843413pillbox
pilling103722563pilling
pillow113110573pill_ow
pinion83815893pi_nion
pulsion938393pulsion
rilling84023623rilling
scallion1046793scallion
scullion1065633scullion
semillon1045343semill_on
silicon9117533silicon
sillier74017593sillier
sillies73425083sillies
sillily10209783sillily
simlin8311733simli_n
sirloin747593sirloin
solion6616383_solion
stallion837523stallion
talion6317713_talion
tiglon737923tigl_on
tilling83522783tilling
tillite7313563tillite
trillions947183trillions
vermillion1553253vermillion
vibrion1245253vibrion
villain1038483villain
villein1036753villein
villi86517853villi__
violin9311983violi_n
virion9310683vi_rion
vision9311313vi_sion
willie94116453willi_e
willied114611563willied
willies103920153willies
willing113821613willing
willow12369693will_ow
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 Filter1786911340270.406440125.6
2DLD Change Limit1340272396.75019855.9
3Display Results2392390.0932569.9
 (SQL Overall)1786912397.24924650.4
 
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.