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

78 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
rectorial1111989(None) 
sectorial111110011sectorial
tectorial11119031tectorial
vectorial14147401vectorial
auctorial11117312auctorial
directorial1453932directorial
doctorial1246692doctorial
factorial1447022factorial
nectarial1147102nectarial
pectoral121210502pector_al
pictorial1348402pictorial
pretorial11512652pre_torial
proctorial1447512proctorial
raptorial1147432raptorial
rectories11314642rectories
restoral8810982restor_al
retrial7615552re_t_rial
sectoral10109542sector_al
sectorials1286522sectorials
suctorial11117722suctorial
tentorial9119602tentorial
bacterial1348363bacterial
cantorial1149813cantorial
censorial11117503censorial
centurial1147953centurial
chorial124214143__chorial
decrial10310323dec__rial
doctoral1146303doctor_al
ectopia1147693_ectopia_
ectopias1248273_ectopias
editorial1047313editorial
electoral1156723elector_al
enchorial1446683enchorial
executorial2052153executorial
factorials1544693factorials
hectoring1538303hectoring
lictorian1166603lictorian
memorial1249523me_morial
pectorals13128153pector_als
pictorials1445493pictorials
praetorial1257093praetorial
precentorial1654983precentorial
preceptorial1853893preceptorial
precocial1547503prec_ocial
pretorian11511553pre_torian
pretrial10511983pre_t_rial
rasorial848223r_asorial
reburial1046203re_burial
recoal84117973rec_o__al
recoil84016723rec_o_i_l
rectal84418133rect___al
rector84019753rector___
rectorate11411363rectorate
rectors93520523rector__s
rectory123512733rector__y
rectrix1645363rect_ri_x
reportorial1353623reportorial
restorals978073restor_als
restoring10314613restoring
retial64724993re_t__ial
retotal739843re_to_tal
retral64419743re_t_r_al
retrials8510823re_t_rials
rhetorical1544573rhetorical
sartorial948383sartorial
sectarian1147533sectarian
sectoring1239583sectoring
senatorial1047323senatorial
sensorial9117453sensorial
suctorian11106503suctorian
tensorial9116793tensorial
tentoria8119263tentoria_
tinctorial1254393tinctorial
tutorial847833_tutorial
vectorially1953903vectorially
vectoring1537413vectoring
victoria1346313victoria_
victorias1446523victorias

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 Filter1786911486410.420425454.8
2DLD Change Limit148641787.22020587.4
3Display Results78780.0302600.0
 (SQL Overall)178691787.67023297.4
 
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.