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

175 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
hampering173886(None) 
hammering1737631hammering
pampering1638381pampering
tampering1438451tampering
bumpering1636592bumpering
cambering16109872cambering
capering132414962ca_pering
chambering20116042chambering
chamfering21125332chamfering
compering163414162compering
dampening1535462dampening
haltering132212012haltering
hamstring1546002hamstring
hankering17239382hankering
happening1735592happening
havering152211052ha_vering
homering141512072hom_ering
lappering14258842lappering
mammering1337332mammering
papering132213312pa_pering
paupering1437272paupering
scampering1745322scampering
simpering1449292simpering
tapering112112502ta_pering
tempering1438732tempering
whimpering2143852whimpering
yammering1735192yammering
adhering1338883_adhering
altering91917123_altering
amberina1247403_amberina
amercing1337193_am_ercing
amping114317573_amp__ing
angering102113803_angering
appearing1436893_appearing
aspersing1237603_aspersing
aspiring1138873_aspiring
badgering1436973badgering
bannering12208813bannering
bantering122414243bantering
barbering14229693barbering
bartering122313653bartering
battering122715153battering
calipering1545003calipering
cameoing1379063cam_eoing
campesino1544633campesino
camping143118973camp__ing
campusing1654913campusing
cankering162110793cankering
cantering122417383cantering
careering12311203careering
carpeting1439483carpeting
catering112019913ca_tering
chaffering22104643chaffering
champing183610933champ__ing
chaptering18107963chaptering
chartering16109253chartering
chattering16108643chattering
chippering2045163chippering
choppering2064813choppering
clambering1776163clambering
comparing162410583comparing
compeering1747053compeering
competing163712463competing
coopering142611323coopering
coppering162810893coppering
cumbering16108203cumbering
dackering1737393dackering
daggering13246113daggering
daikering1536103daikering
damping133414003damp__ing
dandering122511063dandering
dangering12239303dangering
diapering1339033diapering
faltering132211123faltering
fathering161010093fathering
gandering122111293gandering
garnering11298093garnering
gartering112111593gartering
gathering1499463gathering
hachuring1845123hachuring
haeing104118923ha__e_ing
hamboning1745893hamboning
hamming153014093ham__ming
hamper134518653hamper___
hampered16239933hamper_ed
hamperer15379093hamper_er
hamperers16287533hamperers
hampers143616953hamper__s
hamstrings1643013hamstrings
hamstrung1541733hamstrung
hangaring1438033hangaring
hankerings18244753hankerings
hanseling1338063hanseling
happenings1842623happenings
happing153817233ha_p_ping
harboring1538263harboring
hardening1438023hardening
haring104233003ha___ring
harkening1746923harkening
harping134118383harp__ing
hasping134414903hasp__ing
hastening13259483hastening
havening15258553ha_vening
hindering14310273hindering
hollering1337743hollering
hoovering1635753hoovering
hovering151911143h_overing
humoring1456853hum_oring
humouring1544553humouring
humphing1935163hump_hing
humping153213073hump__ing
hungering14187683hungering
hunkering17227123hunkering
impeding1436563_impeding
jabbering2134443jabbering
kashering1736253kashering
kippering18205443kippering
laagering1136833laagering
lackering1639383lackering
laddering1237593laddering
lagering102212313la_gering
lamping123116003lamp__ing
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
limbering1488793limbering
lippering14217883lippering
loppering14237283loppering
lumbering14117933lumbering
mastering122315313mastering
mattering122314063mattering
nattering102212223nattering
numbering14107003numbering
paltering122612903paltering
pandering133211963pandering
pattering122314433pattering
peppering1337083peppering
rampaging1544513rampaging
ramparting1543893ramparting
ramping123316873ramp__ing
rappeling1435963rappeling
rehammering1953363rehammering
sabering112113743sa_bering
saggering12197793saggering
sampling13510643samp_ling
scarpering1545413scarpering
shampooing1843093shampooing
sharpening1644883sharpening
shattering1498283shattering
shimmering1884623shimmering
simmering1467823simmering
stammering1544523stammering
stampeding1642983stampeding
summering1458753summering
supering11317683_supering
tabering112211423ta_bering
tamping122815813tamp__ing
tamponing1445993tamponing
tattering102212333tattering
timbering14117723timbering
umbering1399433_umbering
umpiring1336093_umpiring
vamping152810233vamp__ing
vaporing1437653va_poring
wafering15208893wa_fering
wagering13219523wa_gering
waitering13310723waitering
wandering143310983wandering
watering122316323wa_tering
wavering152410543wa_vering
whispering1944343whispering
yabbering1734023yabbering
yattering132410453yattering
zippering23215203zippering

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.420425454.8
2DLD Change Limit1486411757.00021234.4
3Display Results1751750.0802187.5
 (SQL Overall)1786911757.50023825.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.