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

199 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
alumni85675(None) 
alumin8513541alumin
alumna857341alumna
albumin1145562albumin
alum65227612alum__
alumina9510052alumina
alumine9412692alumine
aluminic1245772aluminic
alumins9512982alumins
alumnae955402alumnae
alumnus935222alumnus
alums75720602alum_s
calumny1443862calumny
abluent939623abluent
acini75718983a_cini
aculei839793aculei
acumen1049013acumen
acumens1136953acumens
adunc837433adu_nc
alamo7418143alam_o
alamos8415003alamos
alan46844083al_an_
aland65526413al_and
alane56135613al_ane
alang66023513al_ang
alanin6317273al_anin
alans55636173al_ans
alant55742293al_ant
albinic1136853albinic
albino839933albino
album92312653album__
albumen1135243albumen
albumens1244143albumens
albumins1245353albumins
albums10198273album_s
aldrin7311243aldrin
alembic1354773alembic
alevin92511513alevin
alexin132311483alexin
alfaki1385383alfaki
algin65718763algin_
algins74816433algins
algum82711763algum__
algums9208043algum_s
alibi7514233al_ibi
alien56425583alien_
aliens65619213aliens
align65016503align_
aligns75312953aligns
aliment9316703aliment
alimony1236013alimony
aline57243153al_ine
alkali10127563alkali
alkane104313323alkane
alkene104114003alkene
alkine104916803alkine
alkyne13436863alkyne
alma66333023al_m_a
almah106917253al_mah
almas76629773al_mas
alme65832163al_m_e
almeh106214553al_meh
almes75126543al_mes
almner85710723al_mner
almond91410433almond
alms65834923al_m_s
almuce10348213almuce
almud84012183al_mud
almude9399933almude
almuds9378773almuds
almug8429303al_mug
almugs9396423almugs
aloin55227423aloin_
aloins65022203aloins
alone55732963al_one
along65419493al_ong
alpine84417373alpine
aludel747853aludel
alula5317093alu_la
alulae6312743alulae
alular6311353alular
aluminas1048353aluminas
alumines10411683alumines
aluminium1344203aluminium
aluminize2045903aluminize
aluminum1274563aluminum
alunite7311633alu_nite
alvine94614583alvine
ami56646813a__m_i
amin66042253a__min
amnia75918643a__mnia
amnic95516243a__mnic
amnio75218053a__mnio
ani37751173a___ni
animi74016663anim_i
arum66129033arum__
arums75517833arum_s
aunt46553653a_u_nt
aurei54821863a_urei
autumn836013autumn_
autumns943763autumns
auxin121411913a_uxin
azuki1864803azu_ki
blini75519273bl_ini
bluing94914483bluing
blume95619893blum_e
blumed114313643blumed
blumes105917793blumes
bluming123511283bluming
blunt75525023blu_nt
calami10313423calam_i
calumet11313293calumet
calumnies1346043calumnies
cluing93913503cluing
clump115517453clum_p
clumps1215314643clumps
clumpy15409573clumpy
clumsy13326193clumsy
clung86013603clu_ng
clunk114215083clu_nk
column1038103column_
columns1136473columns
cumin94616973_cumin
elemi7312503elem_i
eluant6315093eluant
eluent6315483eluent
fluent9313933fluent
flume106021173flum_e
flumed124915263flumed
flumes115119733flumes
fluming133512793fluming
flump124614723flum_p
flumps135112503flumps
flung95114583flu_ng
flunk125014383flu_nk
galumph15102663galumph
gluing83812053gluing
glum75825103glum__
glume85120463glum_e
glumes94516813glumes
glumly12356623glumly
glumpy14527193glumpy
glums84621423glum_s
gluon6311223gluon_
gluons738503gluons
glutei7409743glutei
lauan55216793lauan_
lauans65113533lauans
limbi96513813_limbi
limn66527693_limn_
limnic10418843_limnic
limns75718393_limns
lum55542933_lum__
luma65527523_lum_a
lumas75622913_lumas
lumen75220903_lumen
lumens85013973_lumens
lumina84613543_lumina
lump86531703_lum_p
lumps95624983_lumps
lumpy126615913_lumpy
lums65734243_lum_s
luna46229853_lu_na
lune47140493_lu_ne
lung55732493_lu_ng
lungi65516053_lungi
lunk86030723_lu_nk
lunt46148843_lu_nt
luny77324133_lu_ny
lupin75215843_lupin
muni65824403_mu_ni
plum85122103plum__
plumb114514073plum_b
plumbic1543963plumbic
plumbs12459333plumbs
plume94819463plum_e
plumed114412883plumed
plumes104318133plumes
pluming123412043pluming
plummy15375663plummy
plump115315263plum_p
plumps124612613plumps
plums94619953plum_s
plumy124213233plum_y
plunk114514403plu_nk
plutei8408903plutei
salami8313103salam_i
salmi7815863sal_m_i
saluki1036203salu_ki
sluing74315883sluing
slum65430513slum__
slummy13325863slummy
slump94816633slum_p
slumps104313583slumps
slums74623433slum_s
slung65117833slu_ng
slunk95016303slu_nk
spumoni1173453spumoni
valuing11298843valuing

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161997.69014657.5
3Display Results1991990.0633158.7
 (SQL Overall)1786911997.89322639.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.