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

158 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
palpating143854(None) 
palatine10316072pal_atine
palleting1238742palleting
palliating1347892palliating
palpation1339072palpation
palpations1437652palpations
palping124112872palp__ing
palpitating1644652palpitating
placating1438512placating
plating103823072p_l_ating
pleating112916052p_leating
pulsating1236342pulsating
pupating1337682p_upating
valuating1338652valuating
abating10413973_a_bating
ablating11312003_ablating
adapting1236643_adapting
aerating92821003_aerating
alerting91312383_alerting
aliasing9310073_aliasing
allaying12339313_allaying
aviating12311023_aviating
ballasting1345303ballasting
balloting1238393balloting
balsaming1445123balsaming
bleating113514503_bleating
bloating113512813_bloating
calpain11310413calpa_in_
calpains1239763calpa_ins
carpeting1439483carpeting
caseating12311743caseating
caveating1539293caveating
cleating113518143_cleating
collating12312783collating
delating103119603del_ating
dilating102714913dil_ating
elating83423083_el_ating
epilating12310973epil_ating
evaluating1456023evaluating
fellating1339253fellating
filiating1339253filiating
floating123111883_floating
foliating1339253foliating
gallanting1245353gallanting
galleting1137633galleting
gelating103015733gel_ating
gloating102611463_gloating
halting114419073hal__ting
lactating1239193lactating
lariating10311793lariating
malting103219083mal__ting
mandating1339773mandating
narrating10310353narrating
oxalating1745803oxal_ating
packaging1945163packaging
packeting1836853packeting
paginating1447533paginating
painting113614423pa_inting
paladin101011773pal_adin_
paladins11911003pal_adins
palatial10410623pal_atial
palatines11313043pal_atines
paling93530133pal___ing
palisading1443893palisading
palling104024483pal__ling
palmation13310223palmation
palmations1438733palmations
palming123914013pal__ming
palmitin1248053palmitin_
palmitins1346953palmitins
palpate113213923palpat__e
palpated13249763palpat_ed
palpates122613063palpat_es
palpator1247133palpat_or
palpators1346803palpators
palpatory1645223palpatory
palpitant1345313palpitant
palsying1436233pal_sying
paltering122612893paltering
pampering1638383pampering
pancaking1836383pancaking
panting104025423pa__nting
papain10313793pa_pa_in_
papains11312363pa_pa_ins
papering132213313pa_pering
parading12313863pa_rading
parawing14310583pa_rawing
parbaking1877203parbaking
parenting12611583parenting
pargeting1338283pargeting
parlaying1537303parlaying
parroting1239153parroting
partaking1698673partaking
parting103527383pa__rting
passaging1345613passaging
pasting103826553pa__sting
patenting1248943patenting
patinating1339883patinating
patriating13510203patriating
patting103722343pa__tting
paupering1437273paupering
pelleting1237953pelleting
pelting102917273pel__ting
phonating1537813phonating
pillaging1345573pillaging
pillaring1237653pillaring
piloting1139693pil_oting
pirating11314513p_irating
placing123815283p_l_acing
plaiting113113513p_laiting
planing103418253p_l_aning
planting113515383p_lanting
platina94413643p_l_atina
platings113611363p_l_atings
platting114813033p_latting
playacting1842703playacting
playing133816093p_l_aying
pleading123011443p_leading
pleasing112611593p_leasing
plotting113011013p_lotting
poleaxing1944873poleaxing
polkaing1534633polka_ing
polluting1235703polluting
prating103424453p__rating
predating13514653predating
preparing14311643preparing
prepasting15168883prepasting
prepaving1787233prepaving
prepaying1747973prepaying
probating14311193probating
pronating12313763pronating
prorating12314283prorating
pulping123612323pulp__ing
radiating111112133radiating
ralphing1435413ralp_hing
rampaging1544513rampaging
ramparting1543893ramparting
relating92725443rel_ating
replating122217403replating
salaaming1265363salaaming
salivating1447443salivating
salting84120793sal__ting
saluting9310553sal_uting
salvaging1465283salvaging
satiating10311813satiating
slating83724653_sl_ating
solating9315593sol_ating
solvating1336443solvating
spoliating1366963spoliating
sulfating1338063sulfating
sulphating1644323sulphating
tailgating1244913tailgating
tallaging1146503tallaging
taxpaying2242343taxpaying
vacating14310363va_cating
valeting1238853val_eting
validating1545843validating
variating13310953variating

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.420425454.8
2DLD Change Limit1486411587.51619776.6
3Display Results1581580.0801975.0
 (SQL Overall)1786911588.01622291.8
 
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.