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

221 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
vellum113677(None) 
vellums1235291vellums
velum10713381ve_lum
blellum1143662blellum
helium112311252helium
peplum12156822peplum
skellum1343852skellum
telium82611392telium
velour9328762velour
vexillum2042112vexillum
villus93611222villus
aecium10410423aecium
album92312653_album
algum82711763_algum
allium8311243allium
alum65227613__alum
amylum1344693amylum
asylum1144893asylum
avellan1037293avellan
bdellium1342733bdellium
bedlam1149273bedlam
begum105213923be_gum
belaud939133belaud
beldam11410113beldam
bell66237183bell__
belle75827833bell_e
belled94626193belled
belles85325993belles
bellow114213353bellow
bells76432163bell_s
belly104625493bell_y
blellums1242833blellums
callus85317073callus
cecum11611843ce_cum
cell65031723cell__
cella75420313cell_a
cellae84915933cellae
cellar84514983cellar
celled94420323celled
celli76717693cell_i
cello74919583cell_o
cellos84517803cellos
cells75428063cell_s
cellule936523cellule
celom9515693ce_lom
centum104012363centum
cerium10313763cerium
cesium1039583cesium
chillum1435443chillum
cilium104311373cilium
degum94711903de_gum
dell56938203dell__
dells66630943dell_s
delly96023873dell_y
deplume1255063deplume
ell36735683_ell__
ells46431353_ell_s
elm57531743_e_l_m
fell76833073fell__
fella84918653fell_a
fellah124910773fellah
fellas95116963fellas
felled103720303felled
feller94419553feller
felloe93513923felloe
fellow123712743fellow
fells85327383fell_s
felly114922803fell_y
ferrum1147453ferrum
filum105015433_filum
folium11310453folium
fullam1138363fullam
gallium1037943gallium
gallus74313203gallus
gelled84718893gelled
geum75424553ge__um
glum75825103__glum
hallux1637363hallux
heliums12188303heliums
hell75637893hell__
helled104024703helled
heller93322513heller
hello86522983hell_o
hellos95321683hellos
hells85032043hell_s
helluva1353533helluva
helm95530023he_l_m
hilum105514603_hilum
ileum74512823_ileum
ilium74614183_ilium
illume8298223_illume
jell117125873jell__
jelled144916063jelled
jello126716273jell_o
jellos134714283jellos
jells125522163jell_s
jelly154218253jell_y
kalium1239473kalium
kelim11912553ke_lim
kelly124617023kell_y
kvell12436693kvell__
kvelled15276063kvelled
kvells13346613kvell_s
labellum1274273labellum
lum55542933___lum
medium113711623medium
mell64935613mell__
melled95023023melled
mellow114112223mellow
mells75031333mell_s
mentum104511713mentum
milium104712683milium
nellie63614813nellie
nelly84618813nell_y
neum66723083ne__um
ocellus935983ocellus
oleum73613323_oleum
pablum1237503pablum
pallium1149013pallium
pellet83326553pellet
peplums13145503peplums
peplus10138343peplus
phellem1435833phellem
phylum1655153phylum
pileum10399513pileum
plenum1039503plenum
plum85122103__plum
pullup1045893pullup
realm75621623real_m
rectum103411283rectum
reflux16315413reflux
reglue739703reglue
regnum957163regnum
relume8313273re_lume
replumb1343393replumb
sebum93814553se_bum
sedum84115573se_dum
seldom939413seldom
sell45840613sell__
selle54428313sell_e
seller63824603seller
selles64426983selles
sellout7313583sellout
sells55134433sell_s
sensum849353sensum
septum1038003septum
serum75223473se_rum
siglum936563siglum
skellums1443003skellums
slum65430513__slum
solum74717613_solum
talcum1036953talcum
tectum10328603tectum
tedium9269873tedium
tell44934703tell__
teller63519823teller
tells55828943tell_s
telly84920823tell_y
tellys9348843tellys
tergum937933tergum
vacuum1334833vacuum
valgus1047103valgus
valley124311603valley
valour93010373valour
value85719093v_alue
veal76936813veal__
vealed103916323vealed
vealer94016543vealer
veals84926193veal_s
vealy115817773veal_y
veil75523593veil__
veiled103714543veiled
veiler93814353veiler
veils84918803veil_s
vela75725543ve_l_a
velar85817633ve_lar
velarium1347073velarium
velars93913723velars
velate93720143velate
velcro1144133velcro
veld85323203ve_l_d
velds95615583ve_lds
veldt94819863ve_ldt
veldts10417753veldts
veloce11310133veloce
velours10278083velours
veloute1037733veloute
velure939773velure
velvet123613753velvet
vendue10419013vendue
venom103914863ve_nom
venous93713193venous
venue84918213ve_nue
venule94411763venule
venus84918903ve_nus
verism113214263verism
versus94211143versus
vertu85017613vertu_
vertus94613603vertus
vill75235073vill__
villa85321233vill_a
villae95615383villae
villas96117263villas
villi86517853vill_i
villous102810023villous
vills86429323vill_s
vitellus1144143vitellus
volley12419743volley
volume11358273v_olume
vulgus1035783vulgus
vum85428653v___um
well75832043well__
welled103820213welled
wellie92814913wellie
wells85426193well_s
welly114620013well_y
yell76028323yell__
yelled104116253yelled
yeller94214513yeller
yellow12429883yellow
yells85821943yell_s

Search took 6 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.406440125.6
2DLD Change Limit1127162214.65624208.8
3Display Results2212210.0633507.9
 (SQL Overall)1786912215.12534866.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.