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

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

48 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
compurgators1910294(None) 
compurgator1882821compurgator_
comparators1785682compar_ators
compurgations20123892compurgations
cocurators1447303co_cur_ators
commutators1754433commu_tators
comparator1665803compar_ator_
compensators1854373compensators
compradors1743783comp_r_adors
compurgation19134183compurgation
cooperators1547003cooper_ators
corporators1546653corpor_ators
expurgators2152563_expurgators
amputators1444224_ampu_tators
cocreators1447144co__creators
cocurator1347574co_cur_ator_
combustors1643754combu__stors
commentators1854794commentators
communicators2173984communicators
commutator1644674commu_tator_
compactors18256254comp__actors
compensator1754674compensator_
compensatory2163644compensatory
competitors1753554comp_etitors
compositors1754384comp_ositors
comprador1643594comp_r_ador_
compradore1752744comp_r_adore
compradores1852604comp_r_adores
compressors1754194comp_ressors
computations1848124compu_tations
computers15339754compu___ters
congregators1653834congregators
conservators1755974conservators
conspirators1655534conspir_ators
consummators18134024consummators
cooperator1446834cooper_ator_
copulatory1745754co_pu_latory
corporator1446944corpor_ator_
curators10311724c___ur_ators
depurators1346484_depur_ators
expurgator2052754_expurgator_
expurgatory2452294_expurgatory
imperators1447714_imper_ators
objurgatory2451604_objurgatory
obturators1244304_obtur_ators
operators11410754_o_per_ators
promulgators1751934prom_ulgators
purgatory1544414___purgatory

Search took 8 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.393454684.5
2DLD Change Limit124790486.78018405.6
3Display Results48480.0331454.5
 (SQL Overall)178691487.20624797.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.