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

178 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
caveating153929(None) 
caseating12311741caseating
averting122512732_averting
aviating12311022_aviating
catenating1348682catenating
cavatina1347332cav_atina
cavatine13310322cav_atine
caverning1536282caverning
cavitating1646912cavitating
cavorting1536062cavorting
cheating144014522c_heating
cleating113518142c_leating
coveting141912312cove_ting
creating113921952c_reating
abating10413973_a_bating
abetting1158293_abetting
ablating11312003_ablating
accenting1487833accenting
accepting1695823accepting
acierating1348323acierating
actuating1239233actuating
acylating1547573acylating
advecting1645113advecting
adverting1437223adverting
aerating92821003_aerating
agenting1039383_agenting
alerting91312383_alerting
anearing9413973_anearing
avenging1345863_avenging
averaging1446503_averaging
averring12239063_averring
beating104326873__beating
bleating113514503_bleating
cabbaging1744093cabbaging
cacheting1737153cacheting
cadencing1544963cadencing
cageling12310843cage_ling
cameoing1379063came_oing
canaling112016413ca_naling
canting104725903ca__nting
canulating1349553canulating
canvasing1546433canvasing
capering132414963cape_ring
careening12310013careening
careering12311203careering
caressing1238803caressing
caretaking1765333caretaking
carpeting1439483carpeting
carting104228283ca__rting
cascading1545673cascading
caseation1199513caseation
caseations1258303caseations
casefying1843753casefying
casketing1635383casketing
casting104628343ca__sting
castrating1349773castrating
catering112019913cate_ring
catfacing1744553catfacing
cathecting1844833cathecting
catting103922643ca__tting
cavatinas1444783cav_atinas
caveat11417723caveat___
caveated1439143caveat_ed
caveator1387233caveat_or
caveators1497263caveators
caveats1239803caveat__s
cavetti1245423cavetti__
caviling14310113cav_iling
cavilling1536393cavilling
caving124822613cav___ing
ceasing104118263c__easing
cementing1438763cementing
chelating1549363chelating
clavering1538373clave_ring
cleaning113112383c_leaning
clearing113014883c_learing
cleaving141389683c_leaving
clefting14347583c_lefting
coating103525313c__oating
cocreating15310293cocreating
coheading1636623coheading
coleading1338523coleading
collating12312783collating
combating16310163combating
convecting18310433convecting
conventing16311543conventing
converting16313133converting
corelating13511583corelating
covenanting1743013covenanting
covering142215733cove_ring
crating103725203c__rating
cravening1547553crave_ning
creaking153414123c_reaking
creaming133413143c_reaming
creasing113314443c_reasing
creatin93618133c_reatin_
creatine103417413c_reatine
creatins103617513c_reatins
cremating14312203cremating
cresting114017043c_resting
curating11314293c_urating
curetting1236573curetting
curveting1535353curve_ting
curvetting1643393curvetting
davening13258873dave_ning
defeating142311973defeating
devesting14249903devesting
deviating14311083deviating
diverting142410333diverting
divesting14298483divesting
eating75134403___eating
elevating1338203elevating
everting122213133_everting
excavating2344113excav_ating
faceting1438783face_ting
facetting1535283facetting
gaveling133410163gave_ling
gavelling14286893gavelling
gavotting1443193gavotting
gazetting2043243gazetting
harvesting1744413harvesting
havening15258553have_ning
havering152211053have_ring
heating114024323__heating
ideating10311703_ideating
inventing13109973inventing
inverting131013223inverting
investing13119393investing
lacerating1349453lacerating
lactating1239193lactating
lamenting1237703lamenting
lariating10311793lariating
laureating1146393laureating
laveering1336813laveering
macerating1549543macerating
mandating1339773mandating
miseating121215433miseating
narrating10310353narrating
nauseating1144983nauseating
navigating1545003navigating
obverting1536303obverting
obviating1545053obviating
outeating10814493outeating
palpating1438543palpating
parenting12611583parenting
patenting1248953patenting
pleating112916053_pleating
radiating111112133radiating
ravaging1346323rav_aging
raveling123414373rave_ling
ravelling13269263ravelling
ravening122611293rave_ning
reheating132314913reheating
repeating122618983repeating
reseating102421533reseating
revealing132611883revealing
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
riveting12139443rive_ting
rivetting13256413rivetting
satiating10311813satiating
savaging1356673sav_aging
scavenging1742073scavenging
seating84130683__seating
sweating123213023_sweating
threating131010053threating
treating92519613_treating
unseating10713203unseating
vacating14310363va_cating
valeting1238853vale_ting
valuating1338653valuating
variating13310953variating
vealing114217423__vealing
venting114218093__venting
vesting114618683__vesting
vetting114216563__vetting
wavering152410543wave_ring

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.453394461.4
2DLD Change Limit1486411787.04621095.8
3Display Results1781780.0762342.1
 (SQL Overall)1786911787.57523589.6
 
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.