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

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
dictatorships216249(None) 
dictatorship2062361dictatorship_
directorships2162973directorships
doctorships1954443doc__torships
spectatorships2372273spectatorships
curatorships1954164_curatorships
dictatorial1452734dictator__ial
dictators1247364dictator____s
directorship2063044directorship_
doctorship1854724doc__torship_
editorships1764024edi___torships
factorships2194484fac__torships
rectorships1855524rec__torships
senatorships1754354_senatorships
spectatorship2262164spectatorship_
tutorships1554914___tutorships
vicarships2053854vic_a__rships
authorships19124475_aut_horships
censorships1854595__censorships
coauthorships2392975__coauthorships
curatorship1854065_curatorship_
dealerships1753835d__ealerships
dictator1147265dictator_____
dictatorially1961835dictatorially
donorships1655155d___onorships
editorship1654155edi___torship_
factorship2084525fac__torship_
legislatorships2171095legislatorships
listenerships1861845listenerships
mayorships2054115___mayorships
mentorships1855185__mentorships
moderatorships2262085moderatorships
monitorships1953895_monitorships
motorships1746585___motorships
pastorships1895895__pastorships
praetorships1954545_praetorships
precentorships2362515precentorships
preceptorships2262485preceptorships
proctorships21154625_proctorships
protectorships2362875protectorships
rectorship1755425rec__torship_
senatorship1654485_senatorship_
sizarships2453955si_za__rships
solicitorships2171855solic_itorships
starships1447665__sta__rships
tutorship1455185___tutorship_
vicarship1954075vic_a__rship_
viceroyships2561455vic_eroyships

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.390458182.1
2DLD Change Limit124790489.45313201.1
3Display Results48480.0331454.5
 (SQL Overall)178691489.87618093.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.