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

129 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
vectored143562(None) 
hectored1436871hectored
sectored1138061sectored
doctored1245612doctored
factored1436212factored
lectured11127222lectured
mentored1138002mentored
restored96417192restored
vector113212062vector__
vectors123212592vector_s
ventured1238272ventured
vestured1237462vestured
vetoed10359822ve_to_ed
anchored1438593anchored
beckoned1735783beckoned
bestowed14156613bestowed
bettered113011833bettered
censored11197953censored
centered112513523centered
centred103411683cent_red
chored125321883__chored
cored85044223__c_ored
declared1248743declared
decoded123212383dec_oded
decolored1345663decolored
decoyed14358333dec_oyed
deplored1237223deplored
detoured1036513de_toured
detoxed1636103de_toxed
echoed125211153_echo_ed
electroed1246973electroed
encored10412103_encored
entered82718883_entered
extorted1636233_extorted
featured1237683featured
festered122512103festered
fettered12259493fettered
gestured1036993gestured
gettered10258613gettered
hectare1238463hectare_
hectares1338853hectares
hector113312653hector__
hectors123513263hector_s
lechered1437523lechered
lector83514983lector__
lectors93415763lector_s
lecture9149513lecture_
lecturer10136023lecturer
lectures101310153lectures
lettered92910783lettered
metered103514013me_tered
metred95315143me_t_red
motored1039933_motored
necrosed1137213necrosed
nectaried1245443nectaried
neutered937423neutered
overtired131310253overtired
overtured13169213overtured
pastored1139963pastored
pectized22257593pectized
pectoral121210503pectoral
peltered112510443peltered
pestered112814953pestered
petered103314963pe_tered
pictured1346573pictured
prestored125111673prestored
proctored1446413proctored
rebored105015883re_bored
reckoned1546953reckoned
recoded113115033rec_oded
recolored1246853recolored
recooked15268243recooked
record96117423rec_or_d
recorded122511063rec_orded
recorked15239853rec_orked
rector84019743rector__
rectories11314643rectories
rectors93520513rector_s
rectory123512723rector_y
recurred1137093recurred
rescored114513103rescored
restoked135710533restoked
restore75822973restore_
restorer84813723restorer
restores85222993restores
retired84620143re_tired
retore67630763re_tore_
retorted9312333re_torted
scored94621133_sc_ored
sectioned1246523sectioned
sector83415923sector__
sectoral10109543sectoral
sectors93116443sector_s
secured1059723sec_ured
stored75524213__stored
succored13135173succored
teetered9258303teetered
tentered96412103tentered
textured1695483textured
tutored837553_tutored
vapored1336923v_apored
vectorial14147403vectorial
vectoring1537413vectoring
veered103612743ve__ered
velured1136683ve_lured
veneered1235983veneered
venomed1336653ve_nomed
vented104617923vent__ed
venture10311173venture_
venturer1137243venturer
ventures11311493ventures
verdured13255763verdured
vested104217353vest__ed
vesture10310373vesture_
vestures11311043vestures
vetoer93410063ve_to_er
vetoers10359473ve_toers
vetoes92914083ve_to_es
vetted104316323ve_t_ted
viatores11257683viatores
victor113210673victor__
victoria1346313victoria
victories1448913victories
victors123311183victor_s
victory15326983victor_y
visored1138143v_isored
vizored2034133v_izored
weltered12238433weltered
westered122511863westered

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621296.51322441.6
3Display Results1291290.0632047.6
 (SQL Overall)1786911296.73226543.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.