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

130 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
adverting143722(None) 
advecting1645111advecting
averting122512731a_verting
adhering1338882adher_ing
advertent1356592advertent
advertise1346102advertise
advertising16143612advertising
advertize2245382advertize
advertizing25144302advertizing
alerting91312382a_lerting
asserting1038662asserting
averring12239062a_verring
diverting142410332diverting
everting122213132_everting
inverting131013222inverting
obverting1536302obverting
reverting132315132reverting
abetting1158293a_betting
aborting11710253a_borting
absenting1236993absenting
accenting1487823accenting
accepting1695803accepting
accreting1446333accreting
acierating1348323acierating
adapting1236643ad_apting
addicting1485073addicting
adducting1494303adducting
adeeming1254793ad_eeming
adjuring1735103adjur_ing
adjusting1843833adjusting
admiring1236133admir_ing
admitting1345033admitting
adopting1237453ad_opting
adoring9412523ad_or_ing
adorning1087323ad_orning
adsorbing1344123adsorbing
adulating1178723adulating
advancing1643063advancing
advection1545553advection
advections1645553advections
advective1845233advective
adventive1645813adventive
adventuring1652973adventuring
adverbial1542553adverbial
adversity1643813adversity
advert103215783advert___
adverted1336103advert_ed
advertence1654443advertence
advertency1953233advertency
advertised1544093advertised
advertiser1443613advertiser
advertises1445913advertises
advertisings17131783advertisings
advertized2443793advertized
advertizes2344673advertizes
adverts11308513advert__s
advising1336153adv_ising
advocating1744483advocating
aerating92821003a__erating
affecting1845233affecting
agenting1039383a_genting
airting83616303a__irting
altering91917113alter_ing
amercing1337193a_mercing
angering102113803anger_ing
anteverting1544333anteverting
arresting1038633arresting
asperating1349563asperating
aspersing1237603aspersing
assenting1038163assenting
assorting1037303assorting
attesting1036383attesting
avenging1345863a_venging
averaging1446503a_veraging
aviating12311023a_viating
badgering1436963badger_ing
caveating1539293caveating
caverning1536283caverning
cavorting1536063cavorting
converting16313133converting
covering142215723cover_ing
coveting141912303cove_ting
darting94020663_d_arting
davening13258873dave_ning
denting94422183_d_enting
derating103222283_d_erating
deserting11713143deserting
devesting14249903devesting
devoting1338823_devoting
dieting93616833_die_ting
diverging15226693diverging
divesting14298483divesting
dueting93814393_due_ting
duetting1047183_duetting
exerting162211153_exerting
experting1938053experting
exserting1736663exserting
fevering152510083fever_ing
governing1435533governing
harvesting1744413harvesting
havering152211053haver_ing
hovering151911143hover_ing
ideating10311703id_eating
inserting10914243inserting
inventing13109973inventing
inversing1389623inversing
invertin11910233invertin_
invertins12911023invertins
investing13119393investing
laddering1237593ladder_ing
levering122212503lever_ing
livering122012383liver_ing
overing111918053_over_ing
perverting1646623perverting
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
revesting132814123revesting
revetting132912633revetting
riveting12139443rive_ting
rivetting13256413rivetting
severing122013853sever_ing
subverting1666293subverting
venting114218093__venting
verging123812303__verging
versing112314193__versing
vesting114618683__vesting
vetting114216563__vetting
wadsetting1542913wadsetting
wavering152410543waver_ing

Search took 9 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.423422437.4
2DLD Change Limit1486411308.11018328.1
3Display Results1301300.0602166.7
 (SQL Overall)1786911308.59320794.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.