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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
punctuating164310(None) 
punctuation1543482punctuation
punctuations1643182punctuations
puncturing1543302punctu_ring
actuating1239233__actuating
fluctuating1752603fluctuating
penetrating1447663penetrating
punctation1486053punct_ation
punctations1585353punct_ations
punctuality1852963punctuality
punctuate1343743punctuat__e
punctuated1543373punctuat_ed
punctuates1443453punctuat_es
punctuator1452323punctuat_or
punctuators1552223punctuators
pustulating1445243pu_stulating
uncoating12611923_unc_oating
uncrating12813183_unc_rating
uncreating13310473_uncreating
unstating10711213_unst_ating
annotating1146234annot_ating
cincturing1554264cinctu_ring
cunctation1476914cunct_ation
cunctations1576154cunct_ations
cunctative1744504cunct_ative
denitrating13128334denitrating
dictating1338884_dict_ating
effectuating2151784effectuating
encrusting13125294_encrusting
enucleating1444554enucleating
enunciating1444374enunc_iating
eructating1345694eruct_ating
evacuating1645684evac_uating
eventuating1543254eventuating
functioning1753244functioning
furcating1537784furc__ating
habituating1743234habituating
incrusting13126474_incrusting
incubating1597134_incubating
infatuating1543584infatuating
initiating1149624_initiating
instating10812214_inst_ating
intubating1376714_in_tubating
intuiting1089614_in_tuiting
lactating1239194_lact_ating
lancinating1445454lancinating
lustrating1147784lu_strating
menstruating1553864menstruating
micturating1644884_micturating
mutating112211754mu__t_ating
nictating1237574_nict_ating
nitrating10312674__nitrating
notating92513344__not_ating
nucleating1346944nu_cleating
nutating92411954__nut_ating
outcheating1744874outcheating
outcounting1444304outcounting
outdating11810864ou__tdating
outeating10814494ou__teating
outrating10916404ou__trating
outstating1139364outst_ating
outstunting1243784outstunting
pancaking1836384panc__aking
pancreatin1454234pancreatin_
pancreatins1553844pancreatins
peculating1549164p_eculating
percolating1657324percolating
perpetuating1753804perpetuating
picturing1436034p_ictu_ring
placating1438514plac__ating
postdating1447164p_ostdating
postmating1548604p_ostmating
postulating1447504p_ostulating
precutting1546424prec_utting
procreating1647694procreating
prostrating1449394prostrating
pullulating1442954pullulating
pulsating1236344pu__lsating
punching163310124punc___hing
punctate1246474punct_at__e
punctated1445054punct_at_ed
punctual1243904punctua___l
punctualities1753464punctualities
punctually1773364punctua_lly
punting103318444pun____ting
pupating1337684pu___pating
purchasing1893534purc_hasing
putting103218574pu__t__ting
repunctuation1752524repunctuation
repunctuations1852264repunctuations
resituating1247544resituating
sanitating1149654sanit_ating
sinuating1039684sin__uating
situating1038884__situating
spectating1546624spect_ating
syncopating1953254syncopating
tincturing1343324tinctu_ring
truncating1344234trunc__ating
ulcerating1346984_ulcerating
unabating1246754_un_abating
uncaging1268714_unc__aging
uncaking1539464_unc__aking
uncaring11312844_unc__aring
uncasing11511004_unc__asing
unceasing1239654_unc_easing
uncloaking1784854_uncloaking
uncoatings1384794_unc_oatings
uncoupling1544464_uncoupling
uncuffing1843704_unc_uffing
uncurbing1455514_unc_urbing
uncurling1237114_unc_urling
undoubting14103334_undoubting
undulating1247144_undulating
unquaking2354594_un_quaking
unquoting1944764_un_quoting
unseating10713204_un_seating
unstinting1147304_unstinting
untrusting1186004_untrusting
untucking1644694_un_tucking
untuning937944_un_tu_ning
victualing1643404_victualing

Search took 10 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 Limit1488191218.87616766.4
3Display Results1211210.0602016.7
 (SQL Overall)1786911219.35919093.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.