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

79 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
competitors175355(None) 
competitor1653731competitor_
competitions1845532competitions
compositors1754382compositors
coeditors1245803co__editors
commentators1854793commentators
commutators1754433commutators
compactors18256253comp_actors
comparators1785683comparators
compensators1854373compensators
competition1755773competition
competitive2074763competitive
completions1746913completi_ons
compositor1644633compositor_
cooperators1547003cooperators
noncompetitors2071993noncompetitors
amputators1444224_amputators
campesinos1642434campesino_s
capacitors1643594c_apacitors
cocreators1447154cocre_ators
codebtors1444404co_de_btors
coeditor1145724co__editor_
coexecutors2261694coexecutors
cogitators1346004co_gitators
collectors1446594colle_ctors
combustors1643754com_bustors
comethers1637444com_et_hers
commentator1755274commentator_
commenters16139484comme_nters
commotions1686844commoti_ons
commutator1644674commutator_
compacters18247034comp_acters
compactions1946544compacti_ons
compactor17256024comp_actor_
companions1697264compani_ons
comparator1665804comparator_
comparisons1753974comparisons
compatibles19134144compatibles
compatriots1753544compatriots
compeers143410014compe___ers
compellers1645194compe_llers
compendious1853374compendious
compensator1754674compensator_
compensatory2163644compensatory
competences1956374competences
competes144117244compe__t_es
competing163712464competi__ng
compilers1537054comp__ilers
complainers1744474complainers
completers16298324comp_leters
completion1647304completi_o_n
complexions2443634complexi_ons
complexities25113834complexities
complicitous2052394complicitous
compliers1538294comp_li_ers
composites1648904composit_es
compositions1846254compositions
composters16388334comp_osters
compradors1743784comp_radors
compressors1754194compressors
compurgators19102944compurgators
computations1848124computations
computers15339754comp__uters
computists1644694computi_sts
connectors1448184conne_ctors
convectors1768314conve_ctors
convertors1549134conve_rtors
cooperator1446834cooperator_
cooptions13107764coop_ti_ons
copastors1346994co_p_astors
corporators1546654corporators
correctors1447504corre_ctors
correlators1345604correlators
creditors1245884c__reditors
expeditors2043644_expeditors
imperators1447714_imperators
impetigos1442114_impetigo_s
noncompetitor1962484noncompetitor_
operators11410754_o_perators

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 Filter1786911488190.423422437.4
2DLD Change Limit148819798.98316566.7
3Display Results79790.0302633.3
 (SQL Overall)178691799.43618937.2
 
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.