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

143 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
venturing133755(None) 
vesturing1337201vesturing
adventuring1652972adventuring
aventurin1244032aventurin_
aventurine1344122aventurine
aventurins1344212aventurins
censuring1237602censuring
centering122915142centering
centring112112952cent_ring
denaturing12115852denaturing
enduring10310012_enduring
ensuring9310172_ensuring
entering91920052_entering
enuring8813882_en_uring
featuring1337322featuring
gesturing1136652gesturing
lecturing1237302lecturing
mentoring1239542mentoring
overturing1499412overturing
renaturing11176802renaturing
tentering102313202tentering
tenuring938862ten_uring
texturing1735222texturing
vectoring1537412vectoring
veluring1237562ve_luring
veneering1337662veneering
venting114218092vent__ing
venturi1037202venturi__
venturis1138192venturi_s
aventurines1453753aventurines
bantering122414233bantering
bettering122212753bettering
binturong12112073binturong
cantering122417373cantering
capturing1436623capturing
censoring1238783censoring
censusing1244813censusing
centerings13247663centerings
centrings12227603cent_rings
centupling1543013centupling
centurial1147943centurial
centuries11311333centuries
centurion1165883centurion
centurions1255513centurions
cincturing1554263cincturing
cloturing1245473cloturing
coenduring1444233coenduring
conjuring1937913conjuring
contouring1347013contouring
contusing1239143contusing
culturing1236553culturing
denting94422183dent__ing
denturist1048463denturist
denuding1137113den_uding
detouring1136973detouring
devouring1435953devouring
encoring11312173_encoring
enduing9249723_endu_ing
enquiring19175443_enquiring
ensuing8239543_ensu_ing
enthusing1355213_enthusing
enticing11311803_enticing
eventuating1543253eventuating
everduring1543293everduring
festering132413173festering
fettering132310513fettering
gendering12249753gendering
gentling1048453gent_ling
gettering112310033gettering
hectoring1538303hectoring
henting113719653hent__ing
honouring1336883honouring
indenturing1342873indenturing
injuring1637473_injuring
insuring9311153_insuring
inuring81213013_in_uring
jointuring1843233jointuring
lettering102112073lettering
manuring1139223man_uring
maturing1139953_maturing
measuring1236123measuring
metering112915633me_tering
metring103215293me_t_ring
neutering1038963neutering
nonjuring1756053nonjuring
nurturing1045013nurturing
overcuring16108763overcuring
overtiring141210203overtiring
overturning1545973overturning
pasturing1238433pasturing
peltering122011673peltering
perduring1336013perduring
perjuring1944923perjuring
perturbing1543563perturbing
pestering122315663pestering
petering112516813pe_tering
picturing1436033picturing
posturing1238993posturing
puncturing1543303puncturing
rapturing1245353rapturing
reentering1149983reentering
reinjuring1844423reinjuring
reinsuring1146383reinsuring
rendering112213183rendering
renting84026853rent__ing
repouring12310073repouring
restoring10314613restoring
restring91518783rest_ring
retiring92717413re_tiring
retuning9311583re_tuning
returning1038133re_turning
rupturing1244353rupturing
sectoring1239583sectoring
securing11310413se_curing
sintering101014803sintering
suturing9310373_suturing
teetering10239893teetering
tendering112210813tendering
tenting84621153tent__ing
tincturing1343323tincturing
tonsuring1046503tonsuring
torturing1036253torturing
untiring9312003_untiring
untuning937943_untuning
vapouring1544653vapouring
veering113213683ve__ering
vending124015263ven__ding
veneerings1443583veneerings
venging123710943ven__ging
venoming1436403ven_oming
venture10311173ventur__e
ventured1238273ventur_ed
venturer1137243ventur_er
venturers1245523venturers
ventures11311493ventur_es
venturous1245583venturous
vesting114618683vest__ing
vetoing11309053ve_t_oing
vetting114216563ve_t_ting
vulturine1244673vulturine
weltering13219493weltering
westering132112643westering
wintering13412363wintering

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 Filter1786911486410.1601116818.8
2DLD Change Limit1486411436.82621775.7
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.04925349.8
 
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.