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

112 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
venturers124552(None) 
venturer1137241venturer_
ventures11311491venture_s
adventurers1552432adventurers
censurers11256072censurers
dentures9312452denture_s
endurers9317952_endurers
ensurers8279372_ensurers
enterers82214152_enterers
gesturers1044282gesturers
lecturers11124232lecturers
veneerers1244522veneerers
venters103717732vent__ers
venture10311172venture__
ventured1238272venture_d
venturis1138192ventur_is
venturous1245582venturous
vestures11311042vesture_s
adventurer1442973adventurer_
adventures1444763adventure_s
adventuress1552893adventuress
aventurins1344213aventurins
banterers112410003banterers
capturers1344633capturers
ceintures1136733ceinture_s
censurer10228133censurer_
censures102211623censure_s
centares102913893centare_s
centaureas1242693centaureas
centers94420603cent__ers
centners1057243cent_ners
centres93817123cent_re_s
centuries11311333centuries
conjurers18126233conjurers
denatures1038133denature_s
denture8311893denture__
denuders10165873den_uders
devourers1344093devourers
endurer83210363_endurer_
endures83314603_endure_s
ensurer73011903_ensurer_
ensures73315903_ensure_s
enterer72015633_enterer_
enters64425643_ent__ers
enticers10139093_enticers
entires71517783_entire_s
entrees71813773_ent_rees
enures63919713_en_ure_s
features11310333feature_s
fetterers12267043fetterers
genitures1046123geniture_s
gesturer935983gesturer_
gestures9310013gesture_s
honourers1245573honourers
injurers15286123_injurers
insurers83710133_insurers
lecturer10136033lecturer_
lectures101310163lecture_s
letterers9228113letterers
manurers1037593man_urers
maturers1037383_maturers
measurers1144883measurers
nurturers943353nurturers
overtures121611453overture_s
pasturers1136393pasturers
perjurers18224463perjurers
perturbers1442633perturbers
pesterers112510463pesterers
pewterers14216043pewterers
posturers1137053posturers
reinsurers1043573reinsurers
renatures939453renature_s
renderers10208093renderers
renters74224813rent__ers
rentiers83311763rent_iers
restorers95110113restorers
retirers84311533re_tirers
returners9376553re_turners
securers1057153se_curers
tenderers10227803tenderers
tenters73921103tent__ers
tenures7412013ten_ure_s
textures1597523texture_s
torturers944343torturers
vapourers1443373vapourers
velures1039093ve_lure_s
venders113717003ven__ders
vendues11318623vendu_e_s
veneerer1145033veneerer_
veneers103710293ven__eers
venires103012453ven_ire_s
venomers1336703ven_omers
ventages12119773ventage_s
venter94218723vent__er_
ventless11249053vent_less
ventrals112910003vent_rals
venturi1037203ventu__ri
venturing1337553venturing
venues95115203ven_u_e_s
venules104011483ven_ule_s
venuses103111413ven_use_s
verderers1344843verderers
verdures12247753verdure_s
vesture10310373vesture__
vestured1237463vesture_d
vetivers1435163ve_tivers
vetoers10359473ve_t_oers
vetters104016323ve_t_ters
vintagers13123903vintagers
vintners1134573vint_ners
vultures1137213vulture_s
winterers12209723winterers

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.406440125.6
2DLD Change Limit1486411126.90621523.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.35824285.3
 
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.