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

177 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
carpeting143948(None) 
carpetings1544211carpetings
becarpeting1882792becarpeting
cacheting1737152cacheting
capering132414962ca_pering
careening12310012careening
careering12311202careering
carpetbag1651872carpetbag
carping123521082carp__ing
carting104228282car__ting
casketing1635382casketing
competing163712462competing
corseting12312172corseting
curveting1535352curveting
marketing1636512marketing
pargeting1338282pargeting
recarpeting1674362recarpeting
scarpering1545412scarpering
targeting1137302targeting
accepting1695803accepting
accreting1446333accreting
arresting1038633_arresting
barbering14229683barbering
barreling1238043barreling
bartering122313643bartering
basseting1236153basseting
cageling12310843ca_geling
calipering1545003calipering
cambering16109873cambering
cameoing1379063ca_meoing
campesino1544633campesino
camping143118973camp__ing
campusing1654913campusing
canceling14310163canceling
cankering162110793cankering
canoeing11310213canoe_ing
cantering122417373cantering
canting104725903ca__nting
capelin11510973ca_pelin_
capelins12311133ca_pelins
capping143819673ca_p_ping
carbureting1682953carbureting
carding113922433car__ding
caressing1238803caressing
caretaking1765333car_etaking
caring95137993car___ing
carking144322853car__king
carling103727063car__ling
carnitine1178573carnitine
caroling113317003car_oling
carolling1259413carolling
caroming133312963car_oming
carotin92216733car_otin_
carotins102315583car_otins
carousing1237893carousing
carpentering1753013carpentering
carpet104530093carpet___
carpetbags1751833carpetbags
carpeted1338943carpet_ed
carpets113915333carpet__s
carpings133812383carp__ings
carpooling1545023carpooling
carroming1437683carroming
carrotin102210893carrotin_
carrotins11239963carrotins
carrying14148373car_rying
cartoning12311113cartoning
carving133916773car__ving
caryotin13268353caryotin_
caryotins14248043caryotins
caseating12311743caseating
casting104628343ca__sting
catering112019903ca_tering
cathecting1844833cathecting
catting103922643ca__tting
caveating1539293caveating
cavorting1536063cavorting
charioting1645723charioting
chartering16109253chartering
charting142614193char__ting
closeting1236183closeting
coapting133511613coap_ting
coarsening1345543coarsening
colleting12311053colleting
compering163414163compering
completing1748423completing
compting153013603comp_ting
computing16309853computing
coopering142611323coopering
coopting133411313coop_ting
coppering162810893coppering
corbeling1439033corbeling
cornering12311893cornering
correcting15199303correcting
cosseting1239543cosseting
coveting141912303c_oveting
crafting143710173c_rafting
craping124018713crap__ing
crapping153911453crap_ping
cratering12312653cratering
crating103725203c_r_ating
cravening1547553cravening
creating113921953c_reating
creeling113513363c_reeling
creeping133310103c_reeping
creping122913653c_r_eping
cresting114017043c_resting
cretin82917913c_r_etin_
cretins93216423c_r_etins
crewing133212623c_r_ewing
crusting113612793c_rusting
cupeling1338863c_upeling
curating11314293cur_ating
curetting1236573curetting
curvetting1643393curvetting
dampening1535463dampening
darkening1535683darkening
darting94020663dar__ting
faceting1438783fa_ceting
farseeing1344383farseeing
farting114120753far__ting
ferreting13127693ferreting
galleting1137623galleting
gardening1236513gardening
garmenting1445483garmenting
garnering11298083garnering
garoting10510703gar_oting
garotting1136103garotting
garroting1136953garroting
gartering112111573gartering
greeting103112353_greeting
hampering1738863hampering
happening1735593happening
hardening1438023hardening
harkening1746923harkening
harping134118383harp__ing
harvesting1744413harvesting
jacketing2345643jacketing
karting123716063kar__ting
lappering14258843lappering
lariating10311783lariating
margenting1446153margenting
marketings1743163marketings
marting103325013mar__ting
marveling1537103marveling
narrating10310353narrating
packeting1836853packeting
palleting1238733palleting
palpating1438533palpating
pampering1638383pampering
papering132213313pa_pering
parceling1438443parceling
parenting12611583parenting
pargetings1443713pargetings
pargetting1444943pargetting
parleying1536113parleying
parqueting2243633parqueting
parroting1239153parroting
parting103527383par__ting
paupering1437273paupering
rabbeting1445183rabbeting
racheting1537793racheting
racketing1647873racketing
rappeling1435963rappeling
scampering1745323scampering
scarphing1735243scarp_hing
scarping133312463scarp__ing
scarting113415263scar__ting
sharpening1644883sharpening
tableting1236353tableting
tampering1438453tampering
tapering112112503ta_pering
tarting84222653tar__ting
trapesing1247263trapesing
valeting1238843va_leting
variating13310943variating
warping133715183warp__ing

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.1561145455.1
2DLD Change Limit1486411777.20320636.0
3Display Results1771770.0762328.9
 (SQL Overall)1786911777.43524033.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.