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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
consolidators165329(None) 
consolidator1553281consolidator_
consolidates1563862consolidat_es
consolidations1754742consolidations
conciliators1695393concili_ators
consolatory1684963consol__atory
consolidate1463793consolidat__e
consolidated1663313consolidat_ed
consolidating1753283consolidating
consolidation1655153consolidation
conspirators1655533cons_pirators
collimators1594784co__llimators
conciliator1595594concili_ator_
conciliatory1994214concili_atory
condolatory1754234condol__atory
consecrators1656054cons_ecrators
conservators1755974cons_ervators
consociates1546544consoci_at_es
consociations1747514consoci_ations
consolations1449744consol__ations
conspirator1555654cons_pirator_
constrictors1676014constri_ctors
consultors1286404consul___tors
consummators18134024cons_ummators
contaminators1754884contaminators
invalidators1652864_invalidators
reconsolidates17122224reconsolidat_es
castigators1445545c_as_tigators
chlorinators1753185c_hlorinators
coconspirators2061435cocons_pirators
cogitators1346005c___ogitators
collators11410345c___ol_lators
collimator1494845co__llimator_
communicators2173985communicators
compositors1754385composi__tors
concentrators1754995concentrators
conciliates1546885concili_at_es
conciliations1747205concili_ations
concoctors1346405conco___ctors
concordats1544195conco_rdat__s
condylomatous21111655condylomatous
confabulators20142545confabulators
confiscators19113685con_fiscators
conglomerators1962215conglomerators
congregators1653835con_gregators
consecrator1546385cons_ecrator_
consecratory1954545cons_ecratory
conservator1656375cons_ervator_
conservatory2054755cons_ervatory
considers1238935cons__id__ers
consignors1344305cons__i_gnors
consistory1545575cons__i_story
consociate1446855consoci_at__e
consociated1645215consoci_at_ed
consociating1755575consoci_ating
consociation1648195consoci_ation
consolation13410985consol__ation
consolers112510925consol____ers
conspirations1747725cons_pirations
constellatory1862595constellatory
constipates1546355cons_tipat_es
constipations1747685cons_tipations
constrictor1596125constri_ctor_
constructors1676475cons_tructors
consulates12711105consul__at_es
consultations1546935consul_tations
consulters1297215consul___ters
consultor1176475consul___tor_
consummator17134055cons_ummator_
consummatory21133495cons_ummatory
contaminator1654995contaminator_
contemplators1953575contemplators
continuators14105625con_tinuators
contradictors1883635contradictors
contributors16153915con_tributors
cooperators1547005co__operators
coordinators1553805co_ordinators
corporators1546655corpo__rators
correlators1345595correl__ators
corroborators1762045corroborators
defoliators1543725_defoli_ators
denominators1574095den_ominators
desalinators1353605_desalinators
desolators1146285_desol__ators
inseminators1453765_inseminators
inspirators1345555_ins_pirators
instigators1245925_ins_tigators
insulators1047265_insul__ators
intimidators1554165_intimidators
invalidator1553195_invalidator_
isolators947515__isol__ators
nominators1277555__n_ominators
noncollectors1762805noncollectors
nonsolids1045385nonsolid____s
obligators13195445_o__bligators
oscillators13113645_o_scillators
podsolizations26164375podsolizations
pollinators1354545po__llinators
pontificators2053055pontificators
reconsolidate16122295reconsolidat__e
reconsolidated18132135reconsolidat_ed
reconsolidating1962015reconsolidating
salivators13135755___salivators
solicitors1244215___solicitors
solidagos1142565___solidago_s
sonicators1277065___sonicators
spoliators1244825__spoli_ators
totalisators1251895to_talisators
totalizators2151795to_talizators
unconsolidated1862035unconsolidat_ed
vasodilators1652035_vasodilators

Search took 9 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 Limit1247901118.43614792.6
3Display Results1111110.0631761.9
 (SQL Overall)1786911118.92220028.1
 
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.