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

216 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
priesting123948(None) 
arresting1038632arresting
cresting114017042cr_esting
orienting1038722orienting
pressing112516442pr_essing
pretesting131810682pretesting
printing113216082pri_nting
prising103321452pri_s_ing
prissing113011452pri_ssing
pristine10313502pri_stine
protesting131910252protesting
reesting93118272_reesting
resting85031182_r_esting
riesling939012_riesling
wresting123811832wr_esting
agisting1038243agi_sting
arising83619973ari_s_ing
attesting1036383attesting
besting104923923__besting
biestings12266033_biestings
breasting1239583breasting
briefing1436943brie_fing
brisking15329473bri_sking
brisling112410843bri_sling
bristling1246663bri_stling
creating113921953cr_eating
creeshing1536243creeshing
crestings12298043cr_estings
crisping13319663cri_sping
crusting113612793cr_usting
detesting112610323detesting
devesting14249903devesting
dieting93616833_die_ting
digesting12208673digesting
directing1338823directing
divesting14298483divesting
dressing102810423dr_essing
drifting13338733dri_fting
egesting1039013_egesting
erecting112415063er_ecting
existing1639073exi_sting
fisting113818123_fi_sting
foisting122910503foi_sting
foresting13311363foresting
freshing152611023fr_eshing
fretting122711523fr_etting
friending1495553friending
frighting1736023frighting
frisking16268363fri_sking
fritting123510703fri_tting
frosting12311183fr_osting
frowsting1634683frowsting
greeting103112353gr_eeting
grieving1385893grie_ving
grifting13299263gri_fting
gritting10309983gri_tting
guesting1058463_guesting
harvesting1744413harvesting
heisting123411043hei_sting
histing113720373_hi_sting
hoisting123610903hoi_sting
infesting13109513infesting
ingesting11129623ingesting
investing13119393investing
irising83614423iri_s_ing
jesting154317713__jesting
joisting16328503joi_sting
listing84020593_li_sting
misting103623383_mi_sting
molesting1237753molesting
nesting84320443__nesting
obtesting1245883obtesting
painting113614423pai_nting
parenting12611583parenting
pargeting1338283parge_ting
pargetting1444943pargetting
pasting103826553p__asting
patenting1248943patenting
peising103416763pei_s_ing
pelting102917273p__elting
perfecting1847513perfecting
perishing1539533peri_shing
permeating1539923permeating
persisting1346653persisting
perverting1646623perverting
pestling111010253p__estling
petting103720953p__etting
picoting1338883p_icoting
piecing12410453p_ie_cing
pieing93917653p_ie__ing
piercing1346663p_iercing
piloting1139693p_iloting
pipetting1435513pipetting
pirating11314513p_irating
pishing134314373p_i_shing
pissing103914803p_i_ssing
pitting103618873p_i_tting
pivoting1436183p_ivoting
pleating112916053p_leating
plighting1635563plighting
pointing112813683poi_nting
poising103617103poi_s_ing
posting105622243p__osting
praising113214563prais_ing
prating103424453pr__ating
preacting142412533preacting
precasting15169833precasting
precenting151012153precenting
precessing1598743precessing
predating13514653predating
predestine1349323predestine
predigesting1753683predigesting
preediting1447933preediting
preeing103817673pr_e_eing
preempting1745393preempting
preening113115843pr_eening
preexisting2144223preexisting
preheating16310723preheating
prelecting15310163prelecting
prepasting15168883prepasting
prepping12309763pr_epping
presaging1339393pr_esaging
prescind1338393pr_escind
presenting131013023presenting
presetting131010833presetting
presiding13510903pr_esiding
presifting1638083pr_esifting
presong1039843pr_es_ong
presorting1339983pr_esorting
pressings12269023pr_essings
prestige11310733pr_estige
prestoring13310303pr_estoring
presuming1437663pr_esuming
pretasting13239283pretasting
pretexting20206973pretexting
prettying1536043pr_ettying
preventing161210263preventing
prevuing1457253pr_evuing
preying133114553pr_e_ying
pricing123417343pri__cing
pricking173212603pri_cking
prickling1836533prickling
priding113317543pri__ding
priest84125423priest___
priested1138393priest_ed
priestess1145293priestess
priestlier1242883priestlier
priestly1345843priest_ly
priests93810863priest__s
prigging13299093pri_gging
prilling113413413pri_lling
priming123417373pri__ming
primming15268173pri_mming
primping15338893pri_mping
prinking153212453pri_nking
printings12268103pri_ntings
prisoning1237643prisoning
pristane10310343pri_stane
prizing193514683pri__zing
probating14311193probating
processing15108183processing
professing16106623professing
profiting1549983profiting
progestin1248423progestin_
progestins1348663progestins
projecting22177243projecting
promoting1439923promoting
prompting1637203prompting
pronating12313763pronating
prorating12314283prorating
prosecting15189813prosecting
prosing103319383pr_os_ing
protecting151910213protecting
questing1838273_questing
quieting18228463quie_ting
renesting102514703renesting
renting84026853_r_enting
resiting93521123_r_esiting
restring91518783_r_estring
retesting102614603retesting
retting83425883_r_etting
revesting132814123revesting
rieslings1034493_rieslings
rifting113515003_ri_fting
righting132610853_righting
rinsing82516113_rins_ing
rioting82716393_ri_oting
riposting1236063_riposting
rising74025883_ri_s_ing
risking123914243_ri_sking
riveting12139443_riveting
rivetting13256413_rivetting
roasting93012703_roasting
roosting93411463_roosting
rousting93913273_rousting
rusting83821263_r_usting
sprinting12310033spri_nting
testing86021053__testing
thirsting1335283thirsting
treating92519613tr_eating
trisecting1345503trisecting
trusting93411653tr_usting
trysting12267053tr_ysting
twisting12427813twi_sting
unresting10311133unresting
uprighting1743463uprighting
uprising1138953upri_s_ing
urinating10310653urinating
vesting114618683__vesting
waisting123615213wai_sting
westing115020273__westing
whisting15329543whi_sting
wisting113519743_wi_sting
wrestling1336063wr_estling
writing113713893wri__ting
zesting174515333__zesting

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.406440125.6
2DLD Change Limit1486412167.18620684.8
3Display Results2162160.0962250.0
 (SQL Overall)1786912167.68823242.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.