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

57 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
decretal114635(None) 
decretals1245091decretals
decrial10310322decr_ial
detrital946572detrital
dicrotal1146822dicrotal
excretal1764352excretal
acetal84314903_ac_etal
cereal8315833ce_re_al
credal9311673__credal
crestal9312133__crestal
decadal1137243dec_adal
decal85523233dec___al
decanal1038113dec_anal
decidual1244203decidual
decimal1238083dec_imal
deckel134911043decke__l
decrease1136563decrease
decree93117783decre__e
decreed112710253decre_ed
decreer10269123decre_er
decreers11277623decreers
decrees102513123decre_es
decremental1654673decremental
decrepit1345873decrepit
decretive1547493decretive
decretory1544683decretory
decrials1137133decr_ials
deferral1244353deferral
defrayal1542613defrayal
demersal1145273demersal
dental74319173de__ntal
deprenyl1442733deprenyl
deprival1444603deprival
dermal93614343de_r_mal
deverbal1444483deverbal
ductal938993duc__tal
excreta1674623excreta_
pelletal1045733pelletal
percental1348663percental
recital9412163rec_ital
recreate10313603recreate
rectal84418133rec__tal
scrotal938493_scrotal
secret8325063secret__
secretary1444203secretary
secrete9311073secret_e
secreted1138633secreted
secreter1038513secreter
secretes10410473secretes
secretin10108343secretin
secretly1345183secretly
secretor1045683secretor
secrets9311773secret_s
segetal868383se_getal
societal1045723societal
tectal83713253tec__tal
vegetal1156303ve_getal

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 Filter1786911461620.420425454.8
2DLD Change Limit146162577.84618628.9
3Display Results57570.0134384.6
 (SQL Overall)178691578.27921583.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.