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

103 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
curveting153535(None) 
curvetting1643391curvetting
carpeting1439482carpeting
corseting12312172corseting
coveting141912312c_oveting
curating11314292cur_ating
curetting1236572curetting
curving133912102curv__ing
purveying1843572purveying
surveying1644962surveying
accreting1446333accr_eting
breveting1536263breveting
bucketing1835713bucketing
budgeting1444023budgeting
buffeting1843783buffeting
bulleting1236643bulleting
burdening1335543burdening
bursting1138703bur_sting
cacheting1737153cacheting
careening12310013careening
careering12311203careering
carpetings1544213carpetings
carting104228283car__ting
carving133916773carv__ing
casketing1635383casketing
caveating1539293c_aveating
clavering1538373clavering
closeting1236183closeting
colleting12311063colleting
competing163712463competing
convecting18310433convecting
convening15311203convening
conventing16311543conventing
converting16313133converting
conveying1838323conveying
corbeling1439033corbeling
cornering12311893cornering
correcting15199303correcting
cosseting1239543cosseting
courting112514573cour__ting
covering142215733c_overing
crafting143710173c_rafting
crating103725203c_r_ating
cravening1547553cravening
creating113921953c_reating
creeling113513363c_reeling
creeping133310103c_reeping
creping122913653c_r_eping
cresting114017043c_resting
cretin82917913c_r_etin_
cretins93216423c_r_etins
crewing133212633c_r_ewing
crusting113612793c_rusting
cudgeling1443663cudgeling
cueing94913613cu__e_ing
culverin1345173culverin_
culverins1445373culverins
cumbering16108203cumbering
cupeling1338863cu_peling
curbing123814023cur__bing
curding113515133cur__ding
curdling12228893cur_dling
curing94824783cur___ing
curling104320183cur__ling
currejong1951663currejong
curring103616843cur__ring
currying14196493cur_rying
cursing104217033cur__sing
curtseying1641983curtseying
curtsying1543813curtsying
curvet114720243curvet___
curveted1435293curvet_ed
curvets12399913curvet__s
curvetted1543703curvetted
cutting103817493cu__tting
dueting93814393du__eting
duvetine1245163du_vetine
ferreting13127703ferreting
furcating1537783furcating
greeting103112353_greeting
gusseting1173963gusseting
harvesting1744413harvesting
hurting113914033hur__ting
incurvating1784953incurvating
junketing2143093junketing
marketing1636513marketing
marveling1537103marveling
murdering1357133murdering
outvoting1336823outvoting
pargeting1338283pargeting
perverting1646623perverting
pureeing1137273pur_eeing
quavering2235953quavering
quieting18228463qu_ieting
quivering2235873quivering
riveting12139443_riveting
russeting1065323russeting
subvening1546033subvening
subverting1666293subverting
surfeiting1445023surfeiting
surveyings1741973surveyings
surviving1644163surviving
targeting1137303targeting

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.420425454.8
2DLD Change Limit1486411038.47017549.1
3Display Results1031030.0631634.9
 (SQL Overall)1786911038.95319958.8
 
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.