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

188 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
alumina951005(None) 
alumin8513541alumin_
aluminas1048351aluminas
alumine9412691alumine
alumins9512981alumins
alumna857341alum_na
lumina84613541_lumina
albumin1145562albumin_
albumins1245352albumins
aluminate1149372aluminate
alumines10411682alumines
aluminic1245772aluminic
aluminum1274562aluminum
alumnae955402alum_nae
alumni856752alum_ni
bluming123511282bluming
fluming133512792fluming
lamina84920442_lamina
limina83514502_limina
luminal93711002_luminal
numina83510842_numina
pluming123412042pluming
rumina83412482_rumina
abdomina1343963abdomina
abulia83512503abuli_a
abusing1049113abusing
acumen1049013acumen_
acumens1136953acumens
acuminate1347573acuminate
agnomina1144263agnomina
aiming94320843a_iming
alameda1035493alameda
alanin6317273alanin_
alanine7316863alanine
alanins7315803alanins
alarming1138583alarming
alaruming1243713alaruming
albinal937813al_binal
albino839933al_bino
albumen1135243albumen_
albumens1244143albumens
aldrin7311243aldrin_
aldrins8310203aldrins
alevin92511513alevin_
alevins102110583alevins
alexia132910463alexi_a
alexin132311483alexin_
alexine142410543alexine
alexins141910663alexins
algin65718763al_gin_
algins74816433al_gins
aliment9316703aliment
alimony1236013alimony
aline57243163al__ine
alining81917043alining
aliya83713483al__iya
alkine104916803al_kine
alluding1036953alluding
alluring939073alluring
alluvia1045193alluvi_a
allying113011663allying
alma66333033al_m__a
almanac1156033al_manac
almond91410433al_mond
alodia71112453alodi_a
aloin55227423al_oin_
aloins65022203al_oins
alpine84417373al_pine
alula5317093alu__la
alum65227613alum___
aluminates1248363aluminates
aluminium1344203aluminium
aluminize2045903aluminize
aluminous1145293aluminous
aluminums1343543aluminums
alumnus935223alumnus
alums75720603alum__s
alunite7311633alunite
alvine94614583al_vine
amboina1137963amboina
amia66836903a__mi_a
amiga85514813a__miga
amin66042253a__min_
amine75835383a__mine
amino75425503a__mino
amins75534323a__mins
ammine10314493a_mmine
ammino1069883a_mmino
amnia75918643a__mnia
amusia839173amusi_a
amusing1039383amusing
anemia82613573anemi_a
angina7413133a_ngina
anuria6313133anuri_a
arming94719803a_rming
assuming1135143assuming
auding83616933a_uding
auxin121411913a_uxin_
auxins13129813a_uxins
blaming123515693blaming
blueing103710203blueing
bluing94914483blu_ing
cacuminal1553473cacuminal
calamine12314033calamine
calamint12315133calamint
calming123915973cal_ming
calumny1443863calum_ny
clueing104110103clueing
cluing93913503clu_ing
clumping15319883clumping
culming123811183culming
cumin94616973_cumin_
cumins103314933_cumins
eluding93412113eluding
eluting84115293eluting
eluvia936133eluvi_a
flaming134216443flaming
fluking154410513fluking
flumping16287583flumping
fluting113815093fluting
fluxing18398923fluxing
fulmine1257963fulmine
fuming124013293_fuming
gauming11319713gauming
germina1038503germina
gliming113310133gliming
glueing9338713glueing
gluing83812053glu_ing
illumine1046083illumine
illuming1135873illuming
kalmia1238903kal_mi_a
kluging13356593kluging
lamia75324323_lami_a
laminae93512973_laminae
laminal94113633_laminal
laminar93810283_laminar
laminas93615873_laminas
laming94528363_laming
lamming123014583lamming
latina65621143_latina
lauding93211903lauding
lauwine1036373lauwine
liminal93810673_liminal
liming94021243_liming
lubing94114043_lubing
luging83915293_luging
luma65527523_lum__a
lumen75220903_lumen_
lumenal9307273_lumenal
lumens85013973_lumens
luminary13336653_luminary
lumping123314643_lumping
luna46229853_lu__na
lupin75215843_lupin_
lupine84013533_lupine
lupins84514463_lupins
luring73820753_luring
luting75221753_luting
mina65136933___mina
nomina83113683_nomina
noumena945633noumena
palming123914013pal_ming
palomino1246193palomino
pashmina1543313pashmina
platina94413643platina
plumbing15286433plumbing
plumier113510053plumier
plumping15277633plumping
pluvian1245333pluvian
relumine1038933relumine
reluming11310013reluming
ruminal9289993_ruminal
salina64221123sal__ina
saluting9310553saluting
semina8915573_semina
sliming102913953sliming
sluing74315883slu_ing
slumism1136513slumism
slumming13278383slumming
slumping13359973slumping
spuming1248523spuming
stamina9310793stamina
tegmina1035243tegmina
tegumina1143283tegumina
valuing11298843valu_ing
velamina1345663velamina
vimina11339943_vimina
voluming1435043voluming

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.733243780.4
2DLD Change Limit1340271886.04622167.9
3Display Results1881880.0802350.0
 (SQL Overall)1786911886.85926052.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.