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

44 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
executorial205215(None) 
electoral1156723elec_tor_al
executor1744833executor___
executors1844653executor__s
executory2143723executor__y
executrix1751473execut_ri_x
rectorial11119893_rec_torial
sectorial111110013_sec_torial
tectorial11119033_tec_torial
vectorial14147403_vec_torial
auctorial11117314_auc_torial
directorial1453934direc_torial
doctorial1246694_doc_torial
editorial1047314__editorial
electrical1446144elec_t_rical
enchorial1446684e_nc_horial
equatorial1954204e_quatorial
executer1745314executer___
executers1854184executer__s
executing1945584execut__ing
execution1846304execut__ion
executive2164744execut__ive
executrices2251904execut_rices
executrixes1951284execut_rixes
exequial2443024exequ___ial
exterritorial2062104exterritorial
factorial1447024_fac_torial
nectarial1147104_nec_tarial
pectoral121210504_pec_tor_al
pictorial1348404_pic_torial
piscatorial1553294piscatorial
precentorial1654984precentorial
preceptorial1853894preceptorial
pretorial11512654pre__torial
proctorial1447514proc_torial
prosecutorial1762494prosecutorial
sectoral10109544_sec_tor_al
sectorials1286524_sec_torials
senatorial1047324_senatorial
spectatorial1652664spectatorial
suctorial11117724_suc_torial
tentorial9119604_te_ntorial
tinctorial1254394tinc_torial
tutorial847834___tutorial

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.1731032896.0
2DLD Change Limit148819449.53015615.8
3Display Results44440.0331333.3
 (SQL Overall)178691449.73618353.6
 
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.