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

159 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
vellums123529(None) 
vellum1136771vellum_
blellums1242832blellums
heliums12188302heliums
peplums13145502peplums
skellums1443002skellums
velours10278082velours
velum10713382ve_lum_
villus93611222villu_s
albums10198273_albums
algums9208043_algums
alliums957973alliums
alums75720603__alums
amylums1473603amylums
asylums1243633asylums
bdelliums1442053bdelliums
bedlams1237053bedlams
begums11429493be_gums
belauds1036643belauds
beldams1237053beldams
belles85325993bell_es
bellies94023723bellies
bellows124313303bellows
bells76432163bell__s
blellum1143663blellum_
callus85317073callu_s
cellars93713693cellars
cellos84517803cell_os
cells75428063cell__s
cellule936523cellule
cellules1036813cellules
celoms10412123ce_loms
centums11398783centums
ceriums1139473ceriums
cesiums1136303cesiums
chillums1544163chillums
degums10438623de_gums
dellies83622213dellies
dells66630943dell__s
deplume1255063deplume
deplumes1334943deplumes
ells46431353_ell__s
elms67322703_e_l_ms
fellahs13428393fellahs
fellas95116963fell_as
fellers104117543fellers
fellies104119743fellies
felloes104114373felloes
fellows134212433fellows
fells85327383fell__s
ferrums1265983ferrums
foliums1237173foliums
fullams1236553fullams
galliums1145963galliums
gallus74313203gallu_s
geums85414113ge__ums
glums84621423__glums
helium112311253helium_
hellers103619833hellers
helloes103717453helloes
hellos95321683hell_os
hells85032043hell__s
helluva1353533helluva
helms105619463he_l_ms
illume8298223_illume
illumes9327673_illumes
jellies143816533jellies
jellos134714283jell_os
jells125522163jell__s
kaliums1336603kaliums
kelims1278913ke_lims
kellies113516853kellies
kvells13346613kvell__s
lums65734243___lums
mediums12308723mediums
mellows123812233mellows
mells75031333mell__s
nellies73418723nellies
neums75414253ne__ums
ocellus935983ocellu_s
oleums8358783_oleums
pablums1345123pablums
palliums1236703palliums
pellets94014783pellets
peplum12156823peplum_
peplus10138343peplu_s
phellems1544543phellems
plenums1136533plenums
plums94619953__plums
pullups1134233pullups
realms84913493real_ms
rectums11338523rectums
reglues838713reglues
relume8313273re_lume
relumes9612513re_lumes
replumb1343393replumb
replumbs1442183replumbs
sebums10369813se_bums
sedums93910483se_dums
sellers73721303sellers
selles64426983sell_es
sellouts837483sellouts
sells55134433sell__s
septums1135743septums
serums83916303se_rums
skellum1343843skellum_
slums74623433__slums
solums85211333_solums
talcums1135513talcums
tectums11306423tectums
tediums10266973tediums
telium82611393telium_
tellers73717583tellers
tellies73820503tellies
tells55828943tell__s
tellys9348843tell_ys
vacuums1443403vacuums
valgus1047103valgu_s
valleys13407483valleys
valours10248733valours
values94314943v_alues
vealers103214293vealers
veals84926193veal__s
veilers103911823veilers
veils84918803veil__s
velars93913723ve_lars
velcros1244033velcros
velds95615583ve_l_ds
veldts10417753ve_ldts
velites103417303velites
velour9328763velou_r
veloute1037733veloute
veloutes1136153veloutes
velure939773ve_lure
velures1039093velures
velvets13326693velvets
vendues11318623vendues
venoms114211213ve_noms
venous93713193venou_s
venues95115203ve_nues
venules104011483venules
venus84918903ve_nu_s
verisms123011253verisms
versus94211143versu_s
vertus94613603vertu_s
vexillum2042113vexillum_
villas96117263vill_as
villous102810013villous
vills86429323vill__s
vitellus1144143vitellu_s
volleys13316643volleys
volume11358273v_olume
volumes12298233v_olumes
vulgus1035783vulgu_s
wellies103719073wellies
wells85426193well__s
yellers103912953yellers
yellows13329603yellows
yells85821943yell__s

Search took 10 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.1561145455.1
2DLD Change Limit1340271599.36014319.1
3Display Results1591590.0463456.5
 (SQL Overall)1786911599.56218687.6
 
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.