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

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

75 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
commiserative228327(None) 
commiserate1753892commiserat__e
commiserating2053192commiserating
commiseration1964042commiseration
commemorative2163043commemorative
commiserated1963063commiserat_ed
commiserates1853613commiserat_es
commiserations2053453commiserations
combinative2055134combi__native
commemoratives2262424commemoratives
commiseratingly2571264commiseratingly
communicative2454664communicative
commutative2055844comm__utative
comparative20176214co_m_parative
confederative2253754confederative
configurative2262814configurative
consecrative1957314co__nsecrative
conservative20106994co__nservative
cooperative1847054co__operative
obliterative1753054_obliterative
administrative2072155administrative
alliterative1553875_alliterative
carminative1844895carmi__native
cogitative1645935co_gi__tative
collaborative2092385collaborative
colligative1754355colli__gative
combative1847215co_m___bative
combustive1953755combus___tive
commemorate1653665commemorat__e
commemorating1953075commemorating
commemoration1853885commemoration
commemoratively2671915commemoratively
commensurate1853025commensurat__e
commensuration20162985commensuration
commination171111645commi__nation
commissarial1862015commis_sarial
commissariat1862535commis_sariat
commissaries1852885commis_saries
comparatives21164855co_m_paratives
compensative2154655co_mpensative
competitive2074765co_m_petitive
completive1946235co_mple__tive
concentrative2056215concentrative
conciliative1954165conci_liative
conglomerative22132325conglomerative
consecutive1855955co__nsecutive
conservatives2195195co__nservatives
conservatize26125505co__nservatize
considerate1455475considerat__e
consideration1655525consideration
constative15410105co__ns_tative
continuative1755215conti_nuative
cooperatives1965555co__operatives
corporative1847155co__rporative
correlative1645545co__rrelative
corroborative2062105corroborative
counteractive2055955co_unteractive
deliberative1854055_deliberative
demonstrative1964215demonstrative
desiderative1753685_desiderative
dominative1677395do_mi__native
enumerative1654755enum__erative
imperative1748565__im_perative
iterative12410715____iterative
nominative1597685no_mi__native
nonassertive1553465nonasser_tive
nonfigurative2062825nonfigurative
nonoperative1756285no_noperative
operative141110555_o___perative
postoperative2063285postoperative
proliferative2162355proliferative
reiterative1447545__reiterative
remonstrative1874575remonstrative
remunerative1754765_remunerative
tolerative1346255to___lerative

Search took 10 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 Filter1786911247900.423422437.4
2DLD Change Limit124790759.17013608.5
3Display Results75750.0461630.4
 (SQL Overall)178691759.63918538.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.