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

47 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
preceptorial185388(None) 
precentorial1654981precentorial
preceptorials1962481preceptorials
preceptories1854952preceptories
praetorial1257093pr_ae_torial
preceptor1547313preceptor___
preceptors1657033preceptor__s
preceptory1945473preceptor__y
pretorial11512653pr__e_torial
proctorial1447513proc__torial
rectorial11119893_rec__torial
directorial1453924direc__torial
executorial2052154exec_utorial
pectoral121210504p_ec__tor_al
perceptional1854884perceptional
perceptual1653594percept__ual
pictorial1348404p_ic__torial
piscatorial1553294pisc_atorial
praetorian1256634pr_ae_torian
precensoring1753224precensoring
precentor1348734precentor___
precentors1488334precentor__s
preceptive1947754precept__ive
preceptorship2162444preceptorship
preceptorships2262474preceptorships
precocial1547504prec___ocial
precolonial1554254prec_olonial
predoctoral1663124predoctor_al
prefectural1882804prefectur_al
prehistorian1754594prehistorian
prehistorical2063004prehistorical
prenuptial1453394prenupt__ial
presbyterial1962104presbyterial
pretorian11511554pr__e_torian
pretrial10511984pr__e_t_rial
procuratorial1761564procuratorial
professorial1753664professorial
prosecutorial1762494prosecutorial
protectoral1554934protector_al
raptorial1147434_r__aptorial
receptor1256694_receptor___
receptors1356914_receptor__s
reportorial1353624_reportorial
sectorial111110014_sec__torial
spectatorial1652664spectatorial
tectorial11119034_tec__torial
vectorial14147404_vec__torial

Search took 8 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.283631417.0
2DLD Change Limit124790477.45316743.6
3Display Results47470.0301566.7
 (SQL Overall)178691477.76623009.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.