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

132 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
parlaying153730(None) 
parleying1536111parleying
allaying12339312_allaying
arraying1238752_arraying
palsying1436232pa_lsying
parading12313862par_ading
paralysing16235552paralysing
paralyzing25185202paralyzing
parawing14310582par_awing
parbaking1877202parbaking
parling103823762parl__ing
parodying1655422parodying
parrying14168132par_rying
partaking1698672partaking
partying14168892par_tying
playing133816092p__laying
praying133717322p_r_aying
waylaying1953102waylaying
ablating11312003_ablating
alloying12339143_alloying
allying113011663_a_llying
applying1634653appl_ying
arcading1239763_arcading
assaying1236003_assaying
barraging1337383barraging
belaying143110603_belaying
braying134416313_br_aying
carling103727063carl__ing
carrying14148373car_rying
claying133614303__claying
dallying13368493da_llying
darling93418363darl__ing
delaying133210973_delaying
draying123813843_dr_aying
flaying143914463__flaying
foraying1537433for_aying
fraying143413433_fr_aying
gallying13328933ga_llying
garaging1139043gar_aging
garlanding1344433garlanding
graying124115883_gr_aying
harrying15157643har_rying
hurraying1654323hurraying
inlaying1247893_inlaying
lariating10311793lariating
laying104525703___laying
marling103322773marl__ing
marrying14157233mar_rying
mislaying1557913mislaying
narrating10310353narrating
naysaying1642983naysaying
outlaying1338543outlaying
overlaying1738443overlaying
pacifying2045503pacifying
packaging1945163packaging
paladin101011773pa_ladin_
paladins11911003pa_ladins
palatine10316073pa_latine
paling93530133pa_l__ing
palleting1238743palleting
palliating1347893palliating
palling104024483pa_l_ling
palming123914013pa_l_ming
palpating1438543palpating
palping124112873pa_l_ping
pancaking1836383pancaking
pandying15217663pa_ndying
panfrying1842993panfrying
parang93715513par_a__ng
parasang1147333par_asang
parawings1535823par_awings
parceling1438443parceling
parching164313053par_ching
pardoning1338763pardoning
parenting12611583parenting
pargeting1338283pargeting
parging113318603par__ging
paring94236493par___ing
parking143423043par__king
parlay113713993parlay___
parlayed1435823parlay_ed
parlays123910453parlay__s
paroling113316213par_oling
parring103222063par__ring
parroting1239153parroting
parsing103819553par__sing
parting103527383par__ting
passaging1345613passaging
patriating13510203patriating
paying123722163p___aying
pearling11912013pearl__ing
pervading1636303pervading
phrasing1438013phr_asing
phreaking1936473phreaking
pillaging1345573pillaging
pillaring1237653pillaring
pirating11314513pir_ating
placing123815283p__lacing
planing103418253p__laning
plating103823073p__lating
ploying132811573p__loying
plying124312083p__l_ying
portaging1346843portaging
portraying1645163portraying
prating103424453p_r_ating
prepaying1747973prepaying
preying133114553p_r_eying
prying124114803p_r__ying
purifying1835853purifying
purling103620293purl__ing
purveying1843573purveying
rallying12289013ra_llying
rarefying1654693rarefying
rarifying1646313rarifying
raying105027193__r_aying
relaying122515153_relaying
replaying15259603replaying
salarying1336073sa_larying
sallying12309853sa_llying
sashaying1644593sashaying
slaying113316843__slaying
sparling112714533sparl__ing
splaying14219303_splaying
spraying14299883spr_aying
straying122912693str_aying
tallaging1146503tallaging
tallying12318833ta_llying
tarrying12146723tar_rying
taxpaying2242343taxpaying
unlaying1258363_unlaying
variating13310953variating
varying1429723var__ying

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.436409841.7
2DLD Change Limit1486411327.81319024.8
3Display Results1321320.0462869.6
 (SQL Overall)1786911328.29521542.0
 
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.