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 “adventuring” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
adventuring165297(None) 
adventurism1752722adventurism
adventurist1553652adventurist
aventurin1244042a_venturin_
aventurine1344122a_venturine
aventurins1344222a_venturins
venturing1337552__venturing
admeasuring1551613admeasuring
advantaging1751783advantaging
advecting1645113advect__ing
adventure1344393adventur__e
adventured1543343adventur_ed
adventurer1442973adventur_er
adventurers1552433adventurers
adventures1444763adventur_es
adventuress1552893adventuress
adventurisms1862463adventurisms
adventurists1652543adventurists
adventurous1552453adventurous
adverting1437223advert__ing
advertising16143613advertising
advertizing25144303advertizing
aventurines1453763a_venturines
denaturing12115863_d_enaturing
indenturing1342873indenturing
overturing1499413_overturing
vesturing1337203__vesturing
absenting1236994absent__ing
accenting1487834accent__ing
accentuating1762834accentuating
adhering1338884adhe___ring
adjuring1735104ad___juring
advancing1643064advan__cing
adventitia1452614adventiti_a
adventitial1552124adventitial
adventitias1552284adventitias
adventive1645814advent__ive
adventuristic1961514adventuristic
advertisings17131784advertisings
advertorial1552634advertorial
agenting1039384a_gent__ing
ancestoring1454104ancestoring
armaturing1353974a_rmaturing
assenting1038164assent__ing
avenging1345864a_ven__ging
averring12239064a_ve__rring
averting122512734a_vert__ing
carpentering1753024carpentering
censuring1237604__censuring
centering122915144__centering
centring112112954__cent_ring
coenduring1444234_coenduring
cofeaturing1752344cofeaturing
davening13258874daven___ing
decentering1546484decentering
decentring1446754decent_ring
denting94422184_d_ent__ing
denturist1048464_d_enturist
denuding1137114_d_en_uding
detouring1136974_d_etouring
devouring1435954_d_evouring
enduring10310014___enduring
ensuring9310174___ensuring
entering91920054___entering
enuring8813884___en_uring
eventuating1543254_eventuating
everduring1543294_everduring
featuring1337324__featuring
gesturing1136654__gesturing
inventing13109974invent__ing
inventorying1951284inventorying
jointuring1843234_jointuring
lavendering1642134lavendering
lecturing1237304__lecturing
mentoring1239544__mentoring
misentering1446384misentering
overcuring16108764_overcuring
overtiring141210204_overtiring
overturning1545974_overturning
reentering1149994_reentering
renaturing11176814__renaturing
retexturing1952464retexturing
tentering102313214__tentering
tenuring938864__ten_uring
texturing1735224__texturing
vectoring1537414__vectoring
veluring1237564__ve_luring
veneering1337664__veneering
venting114218094__vent__ing
venturi1037204__venturi__
venturis1138194__venturi_s

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819919.06316420.5
3Display Results91910.0461978.3
 (SQL Overall)178691919.53218746.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.