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

58 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
coagulates1313745(None) 
coagulases13133321coagulases
coagulate1258081coagulate_
coagulated1496531coagulated
canulates11312872c_anulates
coagulants1343332coagulants
coagulase1293402coagulase_
consulates12711102consulates
copulates132612462co_pulates
adulates9311913__adulates
angulates10310863_angulates
calculates1498703calculates
cannulates1247783cannulates
canulate10314553c_anulate_
canulated12310673c_anulated
caudates11310263c_a_udates
cingulate12238603cingulate_
circulates1489283circulates
coadunate1245643coadunate_
coagula1045413coagula___
coagulable1543323coagulable
coagulant1245183coagula_nt
coagulating1545073coagulating
coagulation1447273coagulation
coagulations1546513coagulations
coagulums1441973coagul_ums
coequates2045853coequ_ates
cogitates1247863co_gitates
cognates11311583co_g_nates
collates103019143co__llates
commutates1646463commutates
confabulates1953493confabulates
conflates14311133co_nflates
conjugates2044693conjugates
consulate11612233consulate_
copulate122614113co_pulate_
copulated142710483co_pulated
corelates11314863co_relates
correlates1248673correlates
corrugates1345183corrugates
cumulates13258973c_umulates
cyanurates1543563cyanurates
ejaculates19166443ejaculates
fabulates1447733_fabulates
formulates1546543formulates
granulates1148463granulates
gratulates1157133gratulates
jaculates182810363_jaculates
jugulates1744603_jugulates
maculates132013723_maculates
modulates1238053mo_dulates
osculates11109393_osculates
ovulates1148523_o_vulates
populates132710673po_pulates
postulates1268963postulates
regulates101211723_regulates
tabulates1139143_tabulates
ungulates1048353_ungulates

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603586.28022389.0
3Display Results58580.0331757.6
 (SQL Overall)178691586.71926594.9
 
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.