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

102 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
capstone123765(None) 
capstones1347371capstones
capstan1137902capstan_
capstans1257242capstans
claystone1444682claystone
copestone1397452copestone
dapsone1038462daps_one
earstone848602earstone
soapstone1144142soapstone
topstone1046882topstone
acetone9310793_acetone
astony9510523_a_stony
atone56527983_a__tone
baritone1058643baritone
barytone1356023barytone
burstone1057133burstone
cabezone2144433cabezone
cabstand1344413cabstand
caisson936593caisson_
caissons1036283caissons
calzone1848623ca_lzone
campstool1571883campstool
canton85722993ca_nton_
cantoned111411523ca_ntoned
cantons95221203ca_ntons
canzone1858813ca_nzone
capitate121712183capitate
capitol11258283capito_l
capitols12247333capitols
capon95221873cap__on_
capons104119503cap__ons
capote10315733cap__ote
caprine11314233cap_rine
capriole1276913capriole
capsize2037623caps_ize
capsomer1445773caps_omer
capsule1137343caps_ule
captan101613343cap_tan_
captans111612053cap_tans
caption113513693caption_
captioned1445763captioned
captions123813223captions
captive1438973cap_tive
captor104914603cap_to_r
captors113914983cap_tors
capture1138913cap_ture
carotene1039133carotene
carton84522663ca_rton_
cartoned111312833ca_rtoned
cartons94122473ca_rtons
caseose939163ca_seose
caserne93710063ca_serne
cassene93111543ca_ssene
cassine93817283ca_ssine
castanet10416193ca_stanet
caste75932363ca_st__e
casting104628343ca_sting
castle84918963ca_st_le
castoff1547793ca_stoff
castor84418533ca_sto_r
castors94919443ca_stors
cavatine13310323cavatine
cestode1037963c_estode
chaperone1646563chaperone
claystones1544393claystones
copestones1467613copestones
crustose1045503crustose
curbstone1343813curbstone
cystine1239333c_ystine
dapsones1138383daps_ones
dripstone1244153dripstone
drystone1245123drystone
earstones948523earstones
eyestone1146533eyestone
felstone1146863felstone
flagstone1344283flagstone
gallstone1044823gallstone
gemstone1145843gemstone
gladstone1144623gladstone
hailstone1244853hailstone
halftone1445153halftone
haptene123810933hap_tene
headstone1365473headstone
histone10312843_histone
inkstone1245413inkstone
jackstone2244383jackstone
keystone1545333keystone
lactone9311393la_ctone
loadstone1044493loadstone
marlstone1144593marlstone
mudstone1145553mudstone
oilstone847273oilstone
peptone11310763pep_tone
pipestone1345503pipestone
potstone1039423potstone
sandstone1045643sandstone
soapstones1243893soapstones
stone55431183___stone
sunstone847793sunstone
tinstone848173tinstone
toadstone1044583toadstone
topstones1147013topstones

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621026.80021494.4
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.26624592.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.