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

161 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
paupering143727(None) 
pampering1638381pampering
papering132213311pa_pering
capering132414962ca_pering
hampering1738862hampering
lappering14258842lappering
paltering122612892paltering
pandering133211962pandering
pattering122314422pattering
pauperism1544282pauperism
pauperize2244762pauperize
pauperizing2544502pauperizing
peppering1337082peppering
supering11317682_supering
tampering1438452tampering
tapering112112502ta_pering
adhering1338883_adhering
altering91917113_altering
angering102113803_angering
appearing1436893_appearing
aspersing1237603_aspersing
aspiring1138873_aspiring
auguring1036383_auguring
badgering1436963badgering
bannering12208803bannering
bantering122414233bantering
barbering14229683barbering
bartering122313643bartering
battering122715143battering
bumpering1636593bumpering
calipering1545003calipering
cambering16109873cambering
cankering162110793cankering
cantering122417373cantering
careering12311203careering
carpeting1439483carpeting
catering112019903ca_tering
compering163414163compering
coopering142611323coopering
coppering162810893coppering
cupeling1338863_cupeling
dackering1737383dackering
daggering13246113daggering
daikering1536103daikering
dampening1535463dampening
dandering122511063dandering
dangering12239303dangering
daundering1364463daundering
diapering1339033diapering
faltering132211113faltering
fathering161010093fathering
gandering122111293gandering
garnering11298083garnering
gartering112111573gartering
gathering1499463gathering
gauffering1842453gauffering
haltering132212003haltering
hammering1737633hammering
hankering17239383hankering
happening1735593happening
havering152211053ha_vering
jabbering2134443jabbering
jauping17307193jaup__ing
kashering1736253kashering
kippering18205443kippering
laagering1136833laagering
lackering1639373lackering
laddering1237593laddering
lagering102212313la_gering
lathering13912253lathering
laundering1245183laundering
laureling1035643laureling
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
lippering14217883lippering
loppering14237283loppering
mammering1337333mammering
mastering122315303mastering
mattering122314053mattering
maundering1455353maundering
nattering102212213nattering
neutering1038963neutering
packeting1836853packeting
pairing103716733pa__iring
palavering1644483palavering
palleting1238733palleting
palpating1438533palpating
palping124112873palp__ing
paneling111013623pa_neling
papyrine1546053pa_pyrine
parceling1438443parceling
pargeting1338283pargeting
paring94236493pa___ring
parleying1536113parleying
parring103222063pa__rring
partnering1345553partnering
passerine1147083passerine
pastoring12310853pastoring
pasturing1238433pasturing
patterning1346073patterning
pauper103511943pauper___
paupered13216943pauper_ed
pauperisms1663463pauperisms
pauperized2443753pauperized
pauperizes2344773pauperizes
paupers114311073pauper__s
pausing103912813pau__sing
peering103520353p__eering
peltering122011673peltering
pestering122315663pestering
petering112516813p_etering
pilfering1536393pilfering
piperine122011833p_iperine
plastering1339243plastering
plumpening1742443plumpening
plundering1444173plundering
pondering132411333pondering
portering122012303portering
pothering151911283pothering
pottering122612003pottering
pouring103115863pou__ring
powdering16246503powdering
powering142210803p_owering
preparing14311643preparing
prospering1547173prospering
puckering1835883puckering
pupating1337683p_upating
pupping114412503p_up_ping
pureeing1137273p_ureeing
purring104515823p_u_rring
puttering122611643puttering
quavering2235953quavering
queering1838203_queering
rappeling1435963rappeling
repapering1547043repa_pering
sabering112113743sa_bering
saggering12197793saggering
sauntering1137223sauntering
sauteing937913saute_ing
scampering1745323scampering
scarpering1545413scarpering
scuppering1754023scuppering
simpering1449293simpering
spattering13107793spattering
tabering112211423ta_bering
tattering102212323tattering
tautening1035843tautening
tempering1438733tempering
vaporing1437653va_poring
wafering15208893wa_fering
wagering13219523wa_gering
waitering13310713waitering
wandering143310983wandering
watering122316313wa_tering
wavering152410543wa_vering
yabbering1734023yabbering
yammering1735193yammering
yattering132410443yattering
yauping13357243yaup__ing
zippering23215203zippering

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 Limit1486411617.53019739.8
3Display Results1611610.0802012.5
 (SQL Overall)1786911618.03322244.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.