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 “caplin” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

53 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
caplin10321630(None) 
capelin11510971capelin
caplins113515991caplins
carlin84421821carlin
catlin83819081catlin
cabin94820942ca_bin
cabling124017552cabling
cain65643912ca__in
calif104929102ca_lif
calix145317352ca_lix
calkin123515492calkin
callan83619602callan
calling103826772calling
calpain11310412calpain
capelan1139002capelan
capelins12311132capelins
capiz18514562cap_iz
caplet104226812caplet
capon95221872cap_on
capping143819672capping
capric12411802capric
caprine11314232caprine
capris10415082capris
capsid11312412capsid
captain112111062captain
captan101613342captan
caption113513692caption
carline93923612carline
carling103727062carling
carlins93921912carlins
casein83216452casein
catkin123512382catkin
catling104819792catling
catlins93818842catlins
cauline92215602cauline
caulis85320082caulis
chaplain1546192chaplain
cipolin1148782cipolin
codlin94516442codlin
colin76231692c_olin
complin13312072complin
cyclin1339272cyclin
cymlin1337312cymlin
graplin1058442graplin
kaolin1039582kaolin
lapin75222922lap_in
marlin84220902marlin
napkin1236902napkin
papain10313792papain
paulin8312982paulin
poplin10413482poplin
ratlin64116522ratlin
sapling103217862sapling

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit82551532.34335233.0
3Display Results53530.0134076.9
 (SQL Overall)178691532.48271994.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.