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

231 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
velours1027808(None) 
valours10248741valours
velour9328761velour_
clours85215092_clours
colours95913442colours
detours858042detours
devours1166642devours
dolours8438822dolours
flours94414052_flours
lours55125292__lours
pelorus939272pelorus
repours9310232repours
tenours72610072tenours
valors93413772valo_rs
valour93010372valour_
vapours12277462vapours
velars93913722vel_ars
vellums1235292vellums
veloute1037732veloute
veloutes1136152veloutes
velure939772vel_ure
velures1039092vel_ures
venous93713192venou_s
vetoers10359472vetoers
vigours11285482vigours
amours83512663_amours
arbours93910043arbours
ardours8368883ardours
armours9389853armours
beclouds1345373beclouds
befouls1236053befouls
belabours1343543belabours
belauds1036643belauds
beliers94617383beliers
belongs10408223belongs
belons84119413belo_ns
belows114614183belo_ws
belters93819413belters
bescours1245093bescours
bevors111610343bevo_rs
bezoars1836793bezoars
blurs74619083_bl_urs
bulgurs10397113bulgurs
cellars93713693cellars
celoms10412123celo_ms
cerous85821203cerou_s
clouds94612353_clouds
clour76617283_clour_
clouts87017203_clouts
colors86622373colo_rs
colour85915093colour_
decolours1274413decolours
decors94017773deco_rs
delouse839833delouse
delousers1044663delousers
delouses9310013delouses
delvers113411993delvers
demurs939773de_murs
detour778193detour_
devoirs1175783devoirs
devour1076703devour_
dolors75115313dolo_rs
dolour75710133dolour_
dyvours1453183dyvours
eelpouts1044323eelpouts
elders74817303_elders
eloins65419383_eloins
elopers95112943_elopers
elopes85918163_elopes
elvers93814983_elvers
favours13437093favours
fellers104117543fellers
felonry13294843felonry
felons93615763felo_ns
femurs1136713fe_murs
fervours1453053fervours
fetors91014473feto_rs
floors94112353_floors
flour84916453_flour_
floury12449573_floury
flouts94315273_flouts
fluors94311373_fluors
fours85521493__fours
gelders93812573gelders
giaours834573giaours
glouts74414713_glouts
heliums12188303heliums
hellers103619833hellers
helos84928063helo__s
helotry1345653helotry
helots95217703helo_ts
helpers123311853helpers
honours10339383honours
hours85422393__hours
humours1286443humours
inpours936423inpours
jealous1438093jealou_s
keloids1288663keloids
kelters113813753kelters
kulturs1134723kulturs
labours9349893labours
lemurs837253le_murs
louis57322323__louis
loups75319623__loups
lour45430683__lour_
loury85716753__loury
louts56330273__louts
melders103213913melders
meloids10911453meloids
melons84117713melo_ns
melters93918313melters
memoirs1136803memoirs
meous76120063me_ou_s
odours7418253_odours
ours47237563___ours
parlours1036153parlours
pelotas9410723pelotas
pelters93720313pelters
pilous84717753pilou_s
pours74623183__pours
pylorus1235333pylorus
recoups1188843recoups
recourse1038383recourse
recurs83315803re_curs
redouts81411663redouts
reliers75519213reliers
reloads8911313reloads
reloans7313133reloans
relocks134411293relocks
relooks114010723relooks
repour8310993repour_
rigours8207003rigours
rumours976373rumours
sapours93610623sapours
savours10389343savours
scours84913593_scours
sellers73721323sellers
sellouts837493sellouts
senors63620793seno_rs
serous65023563serou_s
setous64917373setou_s
setouts74110333setouts
slurs54123373_sl_urs
sours55230503__sours
stours65015633_stours
sulfurs1037343sulfurs
tabours94110093tabours
telfers10299073telfers
tellers73717603tellers
telomes9310533telomes
telos55424523telo__s
tenors63217753teno_rs
tenour62610733tenour_
tours55325893__tours
tumours976753tumours
uveous936603uve_ou_s
valgus1047103valgu_s
valkyrs1732163valkyrs
valor83614893valo_r_
valuers10328943valuers
values94314943val_ues
vapors113812693vapo_rs
vapour11378873vapour_
vapoury15284803vapoury
vealers103214293vealers
vectors123212593vectors
veers84521363ve__ers
veilers103911823veilers
veiners104112523veiners
velar85817633vel_ar_
velcro1144133vel_cro
velcros1244033velcros
velds95615583vel__ds
veldts10417753vel_dts
veligers1237023veligers
velites103417303velites
vellum1136773vellu_m
veloce11310133velo_ce
velum10713383vel_u_m
velured1136683vel_ured
velvets13326693velvets
venders113717003venders
vendors113510223vendors
vendues11318623vendues
veneers103710293veneers
venomers1336703venomers
venoms114211213veno_ms
venters103717733venters
venture10311173venture
ventures11311493ventures
venturi1037203venturi
venturis1138193venturis
venues95115203ve_nues
venulous1145713venulou_s
venus84918903ve_nu_s
verdure11287773verdure
verdures12247753verdures
vergers114412633vergers
versers103813523versers
versus94211143versu_s
vertus94613603vertu_s
vespers1239033vespers
vesture10310373vesture
vestures11311043vestures
vetoer93410063vetoer_
vetoes92914083veto_es
vetters104016323vetters
vexers165210403ve_xers
vigors102911483vigo_rs
vigour10256803vigour_
villous102810023villou_s
villus93611223villu_s
vinous93914173vinou_s
visors92912223viso_rs
vizors18328903vizo_rs
vodouns1134763vodouns
vodous1038603vodou_s
volosts1036563volosts
voyeurs1332423voyeurs
vrouws12494743v_rouws
vulgars11306533vulgars
vulgus1035783vulgu_s
vulture1036763vulture
vultures1137213vultures
welders113313413welders
weldors11238003weldors
welters103516063welters
yellers103912953yellers
yelpers12348203yelpers
yours85217883__yours
zealous1637813zealou_s

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.420425454.8
2DLD Change Limit1340272316.53320515.4
3Display Results2312310.0763039.5
 (SQL Overall)1786912317.02925422.0
 
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.