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

105 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
vectoring153741(None) 
hectoring1538301hectoring
sectoring1239581sectoring
doctoring1346182doctoring
factoring1537522factoring
lecturing1237302lecturing
mentoring1239542mentoring
restoring10314612restoring
vectorial14147402vectorial
venturing1337552venturing
vesturing1337202vesturing
vetoing11309052ve_to_ing
anchoring1548323anchoring
beckoning1845773beckoning
becoming1538163bec_oming
bestowing1535803bestowing
bettering122212753bettering
censoring1238783censoring
centering122915143centering
centring112112953cent_ring
choring133617663__choring
coring94433963__c_oring
declaring1339573declaring
decoding132410053dec_oding
decoloring1486313decoloring
decoying15208763dec_oying
deploring1337853deploring
detouring1136973de_touring
detoxing1736313de_toxing
echoing1358613_echo_ing
electroing1346903electroing
encoring11312173_encoring
entering91920053_entering
extorting1746763_extorting
featuring1337323featuring
festering132413173festering
fettering132310513fettering
gesturing1136653gesturing
gettering112310033gettering
hectoringly2052443hectoringly
lechering1538443lechering
lettering102112073lettering
metering112915633me_tering
metring103215293me_t_ring
motoring11410953_motoring
necrosing1247693necrosing
nectarine1146983nectarine
neutering1038963neutering
overtiring141210203overtiring
overturing1499413overturing
pastoring12310853pastoring
pecorini1246553pec_orini
pecorino1246633pec_orino
pectizing2348013pectizing
peltering122011673peltering
pestering122315663pestering
petering112516813pe_tering
picturing1436033picturing
prestoring13310303prestoring
proctoring1546673proctoring
reboring11312783re_boring
reckoning1637643reckoning
recoding122213853rec_oding
recoloring1367583recoloring
recooking16148543recooking
recording131311623rec_ording
recorking16149643rec_orking
rectorial11119893rectorial
rectories11314643rectories
recurring1237953recurring
rescoring12310603rescoring
restoking1438193restoking
restring91518783rest_ring
retiring92717413re_tiring
retorting10613273re_torting
scoring103117213_sc_oring
sectioning1346293sectioning
sectorial111110013sectorial
securing11310413sec_uring
storing83921123__storing
succoring1445873succoring
tectorial11119033tectorial
teetering10239893teetering
tentering102313203tentering
texturing1735223texturing
tutoring938433_tutoring
vaporing1437653v_aporing
vector113212063vector___
vectored1435623vector_ed
vectors123212593vector__s
veering113213683ve__ering
veluring1237563ve_luring
veneering1337663veneering
venoming1436403ve_noming
venting114218093vent__ing
vesting114618683vest__ing
vetchling1843593vetchling
vetting114216563ve_t_ting
victoria1346313victori_a
victorias1446523victorias
victories1448913victories
visoring1238373v_isoring
vizoring2134573v_izoring
weltering13219493weltering
westering132112643westering

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411056.31323545.2
3Display Results1051050.0462282.6
 (SQL Overall)1786911056.78226347.8
 
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.