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

81 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
commemorators186245(None) 
commemorator1772611commemorator_
commemorates1753572commemorat_es
commemorations1953442commemorations
commemorate1653663commemorat__e
commemorated1852933commemorat_ed
commemorating1953073commemorating
commemoration1853883commemoration
commemorative2163043commemorative
commemoratives2262423commemoratives
commentators1854793comme_ntators
cogenerators1553984co_generators
collaborators17142074collaborators
commendatory2253234comme_ndatory
commentator1755274comme_ntator_
communicators2173984communicators
commutators1754434co_m_mutators
comparators1785684co_m_parators
compensators1854374compe_nsators
concentrators1754994concentrators
consecrators1656054conse_crators
contemplators1953574contemplators
cooperators1547004coope__rators
corporators1546654co__rporators
corroborators1762044corroborators
accommodators2261745accom_modators
ameliorators14112525_ameliorators
celebrators1544405c_ele_brators
cocreators1447135cocre___ators
cocurators1447305co___curators
cogenerator1454175co_generator_
collaborator16142205collaborator_
collimators1594785collim__ators
comforters17275195co_m_for_ters
commemoratively2671915commemoratively
commendations2055805comme_ndations
commensurations21182585commensurations
commentates17107615comme_ntat_es
commenters16139485comme___nters
comminatory2055245co_m_minatory
commiserates1853605commiserat_es
commiserations2053455commiserations
communicator2054455communicator_
communicatory2463575communicatory
commutator1644675co_m_mutator_
comparator1665805co_m_parator_
compensator1754675compe_nsator_
compensatory2163645compe_nsatory
competitors1753555compe__titors
compositors1754385co_m_positors
compradors1743785co___mpradors
compurgators19102945co_mpurgators
concentrator1655335concentrator_
condemnatory2052865condem_natory
conglomerators1962215conglomerators
consecrator1546385conse_crator_
consecratory1954545conse_cratory
conservators1755975conse_rvators
conspirators1655535co_nspirators
consummators18134025consum_mators
contaminators1754885contaminators
contemplator1853735contemplator_
convertors1549135conve__r_tors
cooperator1446835coope__rator_
corporator1446945co__rporator_
correlators1345595corre__lators
corroborator1662015corroborator_
corroboratory2061625corroboratory
cremators1369805c__rem__ators
decorators1347875___decorators
enumerators1353955enume__rators
immolators1444275__im_molators
imperators1447715_impe__rators
meliorators13115005__meliorators
moderators1386645mo_de__rators
nomenclators1651915no_menclators
numerators1245555_nume__rators
operators11410755_o_pe__rators
perorators1249355___perorators
redecorators1552665_redecorators
tolerators1046735to_le__rators

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.1401276364.3
2DLD Change Limit124790819.45313201.1
3Display Results81810.0631285.7
 (SQL Overall)178691819.65618505.7
 
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.