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

41 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
correlating148708(None) 
corelating13511581co_relating
cocreating15310292cocre_ating
correcting15199302corre_cting
correlation1358552correlation
correlations1447862correlations
correlative1645542correlative
corrugating1544262corrugating
chelating1549353c__helating
circulating1647733circulating
coagulating1545073coagulating
coerecting15218783coere_cting
collating12312763co__llating
conflating16410003co_nflating
congregating1754283congregating
cooperating1648423cooperating
copulating1549373co_pulating
corbeling1439033corbel__ing
corbelling1546713corbel_ling
cordelling1446383cordel_ling
coronating13410173co_ronating
corotating1349323co_rotating
corrading1338203corr__ading
corralling1345433corral_ling
correlate1149043correlat__e
correlated1346683correlat_ed
correlates1248673correlat_es
correlational15113673correlational
correlatives1753903correlatives
correlator1245693correlat_or
correlators1345593correlators
corrupting1555583corr_upting
corseting12312173corse__ting
coruscating1644693coruscating
creating113921953c__re_ating
cremating14312193c__remating
crenelating1445513crenelating
foredating1577123fo_redating
formulating1765053formulating
misrelating1447273misrelating
relating92725443___relating

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 Filter1786911216330.373479064.3
2DLD Change Limit121633416.22019555.1
3Display Results41410.0162562.5
 (SQL Overall)178691416.60927037.5
 
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.