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

167 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
venturer113724(None) 
venture10311171venture_
ventured1238271ventured
venturers1245521venturers
ventures11311491ventures
adventurer1442972adventurer
censurer10228132censurer
denture8311892denture_
dentures9312452dentures
endurer83210362_endurer
ensurer73011902_ensurer
enterer72015632_enterer
gesturer935982gesturer
lecturer10136022lecturer
veneerer1145032veneerer
venter94218722vent__er
venturi1037202ventur_i
venturis1138192venturis
vesture10310372vesture_
vestured1237462vestured
vestures11311042vestures
adventure1344393adventure_
adventured1543343adventured
adventurers1552433adventurers
adventures1444763adventures
aventurin1244033aventurin
banterer102811773banterer
capturer1246093capturer
ceinture1036313ceinture_
ceintures1136733ceintures
censure92310603censure_
censured11248913censured
censurers11256073censurers
censures102211623censures
centare93113703centare_
centares102913893centares
centaurea1143503centaurea
center84421413cent__er
centered112513523centered
centner946853cent_ner
centre84316643cent_re_
centred103411683cent_red
centres93817123cent_res
centuries11311333centuries
century1237193centur_y
conjurer17117683conjurer
demurer1037873de_murer
denature938063denature_
denatured1146023denatured
denatures1038123denatures
dentural948083dentural
denuder9167603den_uder
devourer1235063devourer
endure74014143_endure_
endured93611213_endured
endurers9317953_endurers
endures83314603_endures
ensure63416003_ensure_
ensured83512943_ensured
ensurers8279373_ensurers
ensures73315903_ensures
enter54726383_ent__er
entered82718883_entered
enterers82214153_enterers
enticer91510423_enticer
entire61617703_entire_
entires71517783_entires
entree61817883_ent_ree
enure53520223_en_ure_
enured73315333_en_ured
enures63919713_en_ures
feature1039853feature_
featured1237683featured
features11310333features
fetterer11207813fetterer
geniture946453geniture_
genitures1046123genitures
gentler8378953gent_ler
gesture839243gesture_
gestured1036993gestured
gesturers1044283gesturers
gestures9310013gestures
honourer1146243honourer
injurer14318473_injurer
insurer73312803_insurer
lecture9149513lecture_
lectured11127223lectured
lecturers11124233lecturers
lectures101310153lectures
letterer8259223letterer
manurer938583man_urer
maturer938973_maturer
measurer1035953measurer
mentored1138003mentored
nurturer844473nurturer
overture111511683overture_
overtured13169213overtured
overtures121611453overtures
pasturer1037523pasturer
perjurer17285903perjurer
perturber1343153perturber
pesterer102412703pesterer
pewterer13256313pewterer
posturer1038923posturer
reinsurer945603reinsurer
renature839323renature_
renatured1047283renatured
renatures939443renatures
renderer9239743renderer
renter64527413rent__er
rentier73618223rent_ier
restorer84813723restorer
retirer74715013re_tirer
returner8397983re_turner
securer958253se_curer
tenderer9228733tenderer
tenter64623933tent__er
tentered96412103tentered
tentier73815923tent_ier
tenure6311613ten_ure_
tenured838363ten_ured
tenures7412013ten_ures
texture1497083texture_
textured1695483textured
textures1597523textures
torturer835493torturer
untruer737113_untruer
vapourer1344263vapourer
vectored1435623vectored
velure939773ve_lure_
velured1136683ve_lured
velures1039093ve_lures
vender103418423ven__der
vendue10419013vendu_e_
vendues11318623vendu_es
veneer94511693ven__eer
veneered1235983veneered
veneerers1244523veneerers
venire93513693ven_ire_
venires103012453ven_ires
venomer1237583ven_omer
ventage11109623ventage_
ventages12119773ventages
vented104617923vent__ed
venters103717733venter_s
ventral103612173vent_ral
venturing1337553venturing
venturous1245583venturous
venue84918213ven_u_e_
venues95115203ven_u_es
venular1037683ven_ular
venule94411763ven_ule_
venules104011483ven_ules
venuses103111413ven_uses
verderer1245373verderer
verdure11287773verdure_
verdured13255763verdured
verdures12247753verdures
vestural1156473vestural
vetiver1336103ve_tiver
vetoer93410063ve_t_oer
vetter93417643ve_t_ter
vintager12104823vintager
vintner1034833vint_ner
vulture1036763vulture_
vultures1137213vultures
winterer112110443winterer

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.466383457.1
2DLD Change Limit1461621676.44022696.0
3Display Results1671670.0602783.3
 (SQL Overall)1786911676.96625651.9
 
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.