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

88 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
preceptorials196248(None) 
preceptorial1853891preceptorial_
precentorial1654982precentorial_
preceptories1854962preceptori_es
preceptors1657053preceptor___s
pectorals13128154p_ec__tor_als
pictorials1445494p_ic__torials
praetorial1257094pr_ae_torial_
praetorians1364624pr_ae_torians
precentors1488344precentor___s
preceptor1547324preceptor____
preceptorship2162444preceptorship
preceptorships2262484preceptorships
preceptory1945484preceptor___y
prehistorians1873314prehistorians
presbyterials2061454presbyterials
pretorial11512654pr__e_torial_
pretorians1258314pr__e_torians
pretrials1158144pr__e_t_rials
proctorial1447514proc__torial_
receptors1356924_receptor___s
rectorial11119894_rec__torial_
sectorials1286524_sec__torials
advertorials1651515_advertorials
credentials1454715credent__ials
directorial1453935direc__torial_
editorials1144525__e_ditorials
executorial2052155exec_utorial_
factorials1544695_fac__torials
pectoral121210505p_ec__tor_al_
pedestrians1453815p_edest_rians
perceptible1953635percept__ible
perceptibly2253155percept__ibly
perceptional1854905perceptional_
perceptions1798195percept__ions
perceptual1653605percept__ual_
peremptorily2161525peremptori_ly
pictorial1348405p_ic__torial_
piscatorial1553295pisc_atorial_
plecopterans1862315plecopter_ans
praetorian1256635pr_ae_toria_n
precensoring1753225precensori_ng
precensors1445465precensor___s
precentor1348735precentor____
precentorship2262485precentorship
precentorships2362515precentorships
preceptive1947765precept__i_ve
precepts14268895precept_____s
precocial1547505prec___ocial_
precolonial1554255prec_olonial_
predoctoral1663135predoctor_al_
preemptors1644235preemptor___s
prefectural1882805prefectur_al_
prehistorian1754605prehistoria_n
prehistorical2063015prehistorical_
prehistories1755345prehistori_es
prelectors1447875prelector___s
prenuptial1453395prenupt__ial_
presbyterial1962115presbyterial_
pretorian11511555pr__e_toria_n
pretrial10511985pr__e_t_rial_
procedurals16101945proce_dur_als
procuratorial1761565procuratorial_
professorial1753665professorial_
professoriats1862805professoriats
proletarians1455595prole_tarians
proletariats1454165prole_tariats
prosecutorial1762495prosecutorial_
protectoral1554935protector_al_
protectories1656825protectori_es
raptorial1147435_r__aptorial_
receiptors1443655_receiptor___s
receptionists1754775_receptionists
receptions1449745_recept__ions
receptor1256695_receptor____
reciprocals1751485_recipro_cals
rectories11314645_rec__tori_es
refectories1646425_refectori_es
repertories1355835_repertori_es
reportorial1353625_reportorial_
restorals978075_r__estor_als
retrials8510825_r__e_t_rials
sectorial111110015_sec__torial_
spectatorial1652665spectatorial_
tectorial11119035_tec__torial_
terrestrials1262225terrest_rials
territorials1253445_territorials
vectorial14147405_vec__torial_

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 Limit124790888.57614551.1
3Display Results88880.0631396.8
 (SQL Overall)178691889.02919790.8
 
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.