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 “cantorial” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
cantorial114981(None) 
cantonal1038902canto_nal
censorial11117502censorial
centurial1147952centurial
factorial1447032factorial
janitorial1744462janitorial
manorial10311082man_orial
raptorial1147432raptorial
sartorial948382sartorial
tentorial9119602tentorial
antral65719413_ant_r_al
armorial1049453_armorial
arterial8313633_arterial
atrial65418943_a_t_rial
auctorial11117323auctorial
authorial1247083_authorial
bacterial1348363bacterial
cafetoria1444043cafetoria_
calvarial1445693calvarial
canonical1347213can_onical
cantal84122033cant___al
cantering122417373cantering
canthal12410053cant__hal
cantoning12310883cantoning
cantor85621523cantor___
cantors94620753cantor__s
cantraip12326393cant_raip
cantrap113310283cant_r_ap
cantrip112910043cant_ri_p
cantrips12318933cant_rips
caporal11410943ca_por_al
captopril1552643captopri_l
central93114473cent_r_al
centrical1348353cent_rical
chorial124214143c__horial
clitoral10106463clitor_al
concordal1445323concordal
conformal1696273conformal
contrail10410983cont_rail
criterial1148163criterial
curatorial1245363curatorial
cursorial1144603cursorial
custodial1244353custodial
doctorial1246693doctorial
editorial1047313editorial
factorials1544703factorials
haustorial1344503haustorial
manubrial1342943manubrial
manurial1047793man_urial
material10314103ma_terial
monitorial1246733monitorial
natatorial1065453natatorial
pastoral10310483pastor_al
pictorial1348403pictorial
praetorial1257093praetorial
pretorial11512653pretorial
rasorial848223ra_sorial
rectorial11119893rectorial
sanatoria947173sanatoria_
sanitoria946673sanitoria_
santeria8311653santeria_
santerias9311843santerias
sectorial111110013sectorial
senatorial1047323senatorial
sensorial9117453sensorial
suctorial11117723suctorial
tectorial11119033tectorial
tensorial9116793tensorial
tentoria8119263tentoria_
tinctorial1254393tinctorial
tonsorial9116743tonsorial
tutorial847833_tutorial
vectorial14147403vectorial

Search took 9 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 Filter1786911486410.420425454.8
2DLD Change Limit148641737.78319098.2
3Display Results73730.0302433.3
 (SQL Overall)178691738.23321704.2
 
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.