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

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

36 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
coassume1210397(None) 
coassumed14112931coassumed
coassumes13103891coassumes
assume897562__assume
consume11510132co_nsume
costume1157852co_stume
reassume1044632reassume
assumed1065293__assumed
assumer965363__assumer
assumes967163__assumes
assure6610773__assure
capsule1137343c_apsule
casque17299273c_asqu_e
cassene93111543c_assene
cassine93817283c_assine
chasse115114603chass__e
chaussure1441773chaussure
coarse84813903coars__e
coassist10298803coassist
coassuming1542653coassuming
cocksure1645133cocksure
coinsure1046933coinsure
consomme1445373consomme
consumed1337923co_nsumed
consumer1238503co_nsumer
consumes12310413co_nsumes
costumed1365033co_stumed
costumer1275103co_stumer
costumes1258013co_stumes
costumey1563523co_stumey
crissum1144843crissum_
possum1057953po_ssum_
possums1145753po_ssums
reassumed1243793reassumed
reassumes1144463reassumes
reassure847343reassure

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 Filter1786911461620.420425454.8
2DLD Change Limit146162367.95318378.2
3Display Results36360.0162250.0
 (SQL Overall)178691368.38921300.6
 
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.