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

39 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
compensatory216364(None) 
compensator1754671compensator_
compensators1854371compensators
commendatory2253232commendatory
combinatory2054023combin_atory
commentator1755273commentator_
commentators1854793commentators
comminatory2055243commin_atory
compensate1646143compensat__e
compensated1844863compensat_ed
compensates1745723compensat_es
compensating1955003compensating
compensation18126503compensation
compensations19136183compensations
compensative2154653compensative
dispensatory18101853dispensatory
amendatory1653114_am_endatory
commensally2054784commensa_lly
commentary1945754commen__tary
communicatory2463574communicatory
comparator1665804comp_arator_
comparators1785684comp_arators
compensable1955194compensa_ble
compensational2073524compensational
competitor1653734compe_titor_
competitors1753554compe_titors
compositor1644634comp_ositor_
compositors1754384comp_ositors
compulsory1951864compuls__ory
compurgator1882824compurgator_
compurgators19102944compurgators
condemnatory2052864condemnatory
consecratory1954544consecratory
conservatory2054754conservatory
cooperator1446834coope_rator_
cooperators1547004coope_rators
copulatory1745754co_p_ulatory
cosignatory1752944cosign_atory
recommendatory24121404recommendatory

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.376475242.0
2DLD Change Limit124790398.82614138.9
3Display Results39390.0331181.8
 (SQL Overall)178691399.23519349.3
 
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.