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

214 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
ventured123827(None) 
venture10311171venture_
venturer1137241venturer
ventures11311491ventures
vestured1237461vestured
adventured1543342adventured
censured11248912censured
centered112513522centered
centred103411682cent_red
denatured1146032denatured
denture8311892denture_
dentures9312452dentures
endured93611212_endured
ensured83512942_ensured
entered82718882_entered
enured73315332_en_ured
featured1237682featured
gestured1036992gestured
lectured11127232lectured
mentored1138002mentored
overtured13169212overtured
renatured1047292renatured
tentered96412102tentered
tenured838362ten_ured
textured1695482textured
vectored1435632vectored
velured1136682ve_lured
veneered1235982veneered
vented104617922vent__ed
venturers1245522venturers
venturi1037202ventur_i
venturis1138192venturis
verdured13255762verdured
vesture10310372vesture_
vestures11311042vestures
adventure1344393adventure_
adventurer1442973adventurer
adventures1444763adventures
antired82316193_antired
apertured1244063apertured
aventurin1244033aventurin
bantered113313633bantered
bettered113011843bettered
cantered113415983cantered
captured1336573captured
ceinture1036313ceinture_
ceintures1136733ceintures
censored11197953censored
censure92310603censure_
censurer10228133censurer
censures102211623censures
censused11184973censused
centare93113703centare_
centares102913893centares
centaurea1143503centaurea
centre84316643cent_re_
centres93817123cent_res
centupled14143163centupled
centuries11311333centuries
century1237193centur_y
cinctured1444273cinctured
clotured11246163clotured
coendured1344093coendured
conjured18117903conjured
contoured1237303contoured
contused1138443contused
cultured1137233cultured
denature938073denature_
denatures1038133denatures
dentated10411703dentated
dented84120513dent__ed
dentiled1039743dentiled
dentural948083dentural
denuded10167663den_uded
detoured1036513detoured
devoured1335723devoured
encored10412103_encored
endued83910373_endu_ed
endure74014143_endure_
endurer83210363_endurer
endures83314603_endures
enquired18255793_enquired
ensued73610483_ensu_ed
ensure63416003_ensure_
ensurer73011903_ensurer
ensures73315903_ensures
enterer72015633_enterer
enthused1245083_enthused
enticed101411193_enticed
entire61617703_entire_
entires71517783_entires
entree61817883_ent_ree
enure53520223_en_ure_
enures63919713_en_ures
eventuated14103713eventuated
feature1039853feature_
features11310333features
fendered13258673fendered
festered122512113festered
fettered12259493fettered
gendered11258873gendered
geniture946453geniture_
genitures1046123genitures
gentled9389093gent_led
gesture839243gesture_
gesturer935983gesturer
gestures9310013gestures
gettered10258613gettered
hectored1436883hectored
hented104218753hent__ed
honoured1236313honoured
indentured1243123indentured
injured15339063_injured
insured83714253_insured
inturned9268313_inturned
inured73114813_in_ured
jointured17133483jointured
lecture9149523lecture_
lecturer10136033lecturer
lectures101310163lectures
leisured934763leisured
lettered92910783lettered
manured1039473man_ured
matured10310043_matured
measured1136463measured
metered103514013me_tered
metred95315143me_t_red
natured838963_natured
neutered937423neutered
nurtured935253nurtured
overcured15148643overcured
overtired131310253overtired
overture111511683overture_
overtures121611453overtures
overturned1445303overturned
pastured1138233pastured
peltered112510453peltered
perdured12287403perdured
perjured18286273perjured
perturbed1443353perturbed
pestered112814973pestered
petered103314973pe_tered
pictured1346573pictured
postured1139493postured
punctured1444183punctured
raptured1155473raptured
reentered1038573reentered
reinjured1744533reinjured
reinsured1036983reinsured
renature839333renature_
renatures939453renatures
rendered102512263rendered
rented74426593rent__ed
repoured1139563repoured
restored96417193restored
retired84620143re_tired
retuned86613973re_tuned
returned9459133re_turned
ruptured1144683ruptured
sectored1138073sectored
secured1059723se_cured
sintered92213903sintered
sutured8310373_sutured
teetered9258303teetered
tendered102510603tendered
tented74221003tent__ed
tenure6311613ten_ure_
tenures7412013ten_ures
texture1497083texture_
textures1597523textures
tinctured1243513tinctured
tonsured976383tonsured
tortured935843tortured
uncured10513233_uncured
unensured1044943unensured
unentered1037573unentered
untired82316383_untired
untuned82010823_untuned
unturned9228563_unturned
vapoured1434353vapoured
veered103612743ve__ered
velure939773ve_lure_
velures1039093ve_lures
vended114416353ven__ded
vendue10419013vendu_e_
vendues11318623vendu_es
veneerer1145033veneerer
venged114011993ven__ged
venire93513693ven_ire_
venires103012453ven_ires
venomed1336653ven_omed
ventage11109623ventage_
ventages12119773ventages
venter94218723vent__er
venters103717733venter_s
ventral103612173vent_ral
venturing1337553venturing
venturous1245583venturous
venue84918213ven_u_e_
venues95115203ven_u_es
venule94411763ven_ule_
venules104011483ven_ules
venuses103111413ven_uses
verdure11287773verdure_
verdures12247753verdures
vested104217353vest__ed
vestural1156473vestural
vetoed10359823ve_t_oed
vetted104316323ve_t_ted
vulture1036763vulture_
vultures1137213vultures
weltered12238433weltered
westered122511873westered
wintered122111573wintered

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622146.79621507.1
3Display Results2142140.0932301.1
 (SQL Overall)1786912147.31224438.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.