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 “pacesetting” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
pacesetting165263(None) 
presetting131010832p_resetting
bassetting1344633ba_ssetting
besetting12268423__besetting
facetting1535283fac__etting
pacesetter1452393pacesett_er
pacesetters1552023pacesetters
packeting1836853pac_ke_ting
pargetting1444943pa_rgetting
poussetting1452813poussetting
presenting131013023p_resenting
presettling1444453p_resettling
resetting102816293__resetting
typesetting1752223typesetting
wadsetting1542913wa_dsetting
abetting1158294_a__betting
absenting1236994_a_bsenting
accenting1487824_ac_centing
accepting1695804_ac_cepting
accreting1446334_accre_ting
acerbating1546284_acerbating
acquitting2243654_acquitting
assenting1038164_a_ssenting
asserting1038664_a_sserting
babysitting1951614babysitting
backfitting2353074backfitting
basseting1236154ba_sse_ting
bayonetting1751634bayonetting
begetting13186584__begetting
besotting12256874__besotting
brevetting1644334_brevetting
cacheting1737154cac_he_ting
caseating12311744__caseating
cementing1438764__cementing
curetting1236574__curetting
deserting11713144__deserting
eyeletting1442874_eyeletting
facelifting2052114facelifting
faceting1438784fac__e_ting
filmsetting1751874filmsetting
gazetting2043244ga__zetting
insetting1079284__insetting
jacketing2345644jac_ke_ting
lacerating1349444lace_rating
macerating1549534mace_rating
missetting13107904_missetting
nauseating1144984na_useating
offsetting1742334_offsetting
oversetting1548814oversetting
pacemaking2144384pace_making
palleting1238734pa_lle_ting
parenting12611584pa__renting
pargeting1338284pa_rge_ting
parqueting2243634parque_ting
pasting103826554pa__s__ting
patenting1248944pa__tenting
patting103722344pa____tting
peacekeeping2361034peacekeeping
pestering122315664p__estering
pestling111010254p__es_tling
petting103720954p____etting
photosetting1854254photosetting
picketing1835684pic_ke_ting
pipetting1435514p__ipetting
pirouetting1442694pirouetting
pocketing1875854poc_ke_ting
praelecting1644534praelecting
precenting151012154p_recenting
precutting1546424p_recutting
preelecting1646474preelecting
preerecting1646144preerecting
preheating16310724p_reheating
prelecting15310164p_relecting
preselling1338694p_reselling
preserving1637364p_reserving
presifting1638084p_resifting
presorting1339984p_resorting
pretesting131810684p_retesting
pretexting20206974p_retexting
preventing161210264p_reventing
priesting1239484pries__ting
prosecting15189814p_rosecting
racheting1537794rac_he_ting
racketing1647874rac_ke_ting
recementing1645224recementing
reletting102713944__reletting
reseating102421534__reseating
resecting122816484__resecting
resenting102619294__resenting
resettling1135894__resettling
resitting103414874__resitting
revetting132912634__revetting
rewetting132710444__rewetting
russetting1184254_russetting
setting83621394____setting
somersetting1552184somersetting
tabletting1344094ta_bletting
typesettings1851254typesettings
unsetting1088994__unsetting
upsetting1275564__upsetting

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191008.34317837.6
3Display Results1001000.0931075.3
 (SQL Overall)1786911008.85920170.6
 
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.