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

124 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
parleying153611(None) 
parlaying1537301parlaying
palleting1238742palleting
palsying1436232pa_lsying
parceling1438442parceling
pargeting1338282pargeting
parling103823762parl__ing
parodying1655422parodying
parrying14168132par_rying
partying14168892par_tying
preying133114552p_r_eying
purveying1843572purveying
allaying12339313_allaying
alleging1038473_alleging
alloying12339143_alloying
allying113011663_a_llying
applying1634653appl_ying
arraying1238753_arraying
barbering14229683barbering
barreling1238043barreling
bartering122313643bartering
blarneying1641943blarneying
careening12310013careening
careering12311203careering
carling103727063carl__ing
carpeting1439483carpeting
carrying14148373car_rying
dallying13368493da_llying
darkening1535683darkening
darling93418363darl__ing
farseeing1344383farseeing
fleying14329873__fleying
gallerying1543033gallerying
galleting1137633galleting
gallying13328933ga_llying
gardening1236513gardening
garnering11298083garnering
gartering112111573gartering
gleying12318433__gleying
greying124110893_gr_eying
hardening1438023hardening
harkening1746923harkening
harrying15157643har_rying
lackeying1934923lackeying
marketing1636513marketing
marling103322763marl__ing
marrying14157223mar_rying
marveling1537103marveling
pacifying2045503pacifying
packeting1836853packeting
paling93530133pa_l__ing
palling104024483pa_l_ling
palming123914013pa_l_ming
palping124112873pa_l_ping
paltering122612893paltering
pampering1638383pampering
pandering133211963pandering
pandying15217663pa_ndying
paneling111013623pa_neling
panelling1239073panelling
panfrying1842993panfrying
papering132213313pa_pering
parading12313863par_ading
paralleling1463103paralleling
paralysing16235553paralysing
paralyzing25185203paralyzing
parawing14310583par_awing
parbaking1877203parbaking
parcelling1546173parcelling
parching164313053par_ching
pardoning1338763pardoning
parenting12611583parenting
pargetings1443713pargetings
pargetting1444943pargetting
parging113318603par__ging
paring94236493par___ing
parking143423043par__king
parley116718363parley___
parleyed1436243parley_ed
parleyer1335633parley_er
parleyers1444703parleyers
parleys125212373parley__s
paroling113316213par_oling
parqueting2243633parqueting
parring103222063par__ring
parroting1239153parroting
parsing103819553par__sing
partaking1698673partaking
parting103527383par__ting
partnering1345553partnering
pattering122314423pattering
paupering1437273paupering
paying123722163pa___ying
pearling11912013pearl__ing
pelleting1237953pelleting
perplexing2243143perplexing
phoneying1844283phoneying
playing133816093p__laying
ploying132811573p__loying
plying124312083p__l_ying
pollening1236923pollening
portering122012303portering
praying133717323p_r_aying
preeing103817673p_r_eeing
preening113115843p_reening
prying124114803p_r__ying
pureeing1137273pur_eeing
purifying1835853purifying
purling103620293purl__ing
rallying12289013ra_llying
rarefying1654693rarefying
rarifying1646313rarifying
relying112914613__relying
sallying12309853sa_llying
sparling112714533sparl__ing
surveying1644963surveying
tableting1236353tableting
tallying12318833ta_llying
targeting1137303targeting
tarrying12146723tar_rying
valeting1238853va_leting
varying1429723var__ying
volleying1643763volleying
waylaying1953103waylaying

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 Limit1486411247.68619339.2
3Display Results1241240.0631968.3
 (SQL Overall)1786911248.17221866.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.