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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
pastoral1031048(None) 
pastorale1147311pastorale
pastorali1146241pastorali
pastorals1147951pastorals
pastural1038411pastural
postoral10311721postoral
astral66919282_ast_ral
gastral8329552gast_ral
pastor84817482pastor__
pastorales1247132pastorales
pastorally1565442pastorally
pastorate11411172pastorate
pastored1139962pastored
pastorly1345782pastorly
pastors94119002pastor_s
pectoral121210502pectoral
plastral1046912plast_ral
postural1049202postural
restoral8810982restoral
unpastoral1252282unpastoral
aboral8314373_a_boral
amoral8314633_a_moral
antral65719413_ant_ral
apteral9311523_apteral
asternal858323_asternal
astrals75515243_ast_rals
astray95615543_ast_ray
atonal6514023_a_tonal
auroral7310473_auroral
austral73411513aust_ral
balmoral1244633balmoral
bestowal1344513bestowal
cantonal1038903cantonal
cantorial1149803cantorial
caporal11410943ca_poral
castor84418533castor__
castors94919443castor_s
clitoral10106463clitoral
diastral946993diast_ral
doctoral1146303doctoral
estral64716513_est_ral
factorial1447023factorial
gestural946033gestural
haftorah17123923haftorah
haustorial1344503haustorial
lateral7313573la_teral
litoral7610763_litoral
littoral845273littoral
lustral7339653lust_ral
mayoral1237693ma_yoral
mistral91013643mist_ral
natural739513na_tural
pakora1247283pa_kora_
pakoras1337473pa_koras
palestral1145323palest_ral
pandora1039543pandora_
pandoras11310053pandoras
papyral1445773pa_pyral
parfocal1565393parfocal
parral85517533pa__rral
partial92616263part_ial
pascal10812373pas__cal
paschal14157243pas_chal
passional1146043passional
pasta76624533past__a_
pastas85422873past__as
pastel85918713past__el
paster85734373paster__
pastern94415063paster_n
pasterns104112623pasterns
pasters94531733paster_s
pastil85018323past__il
pastina93914593pastina_
pastinas103712153pastinas
pastoralism1555793pastoralism
pastoralist1357463pastoralist
pastorates12410143pastorates
pastoring12310853pastoring
pastorium1347693pastorium
pastrami1246333past_rami
pastromi1256353pastromi
pastry114913033past_r_y
pasturage1244923pasturage
pasture9311463pastur_e
pastured1138233pastured
pasturer1037523pasturer
pastures10311963pastures
paternal1038333pa_ternal
patrol83213023pa_t_rol
patronal1048653patronal
pectorals13128153pectorals
peroral9314793p_eroral
peytral1287503peyt_ral
pictorial1348403pictorial
pistol83313333pisto__l
postal84317533post__al
postanal1048053postanal
postgrad1245493postgrad
posttrial1146513posttrial
praetorial1257093praetorial
premoral1249713premoral
preoral9312673p_reoral
pretorial11512653pretorial
raptorial1147433raptorial
rasbora945943rasbora_
rasboras1045893rasboras
rasorial848223ras_orial
restorals978073restorals
rostral7311333rost_ral
sartorial948383sartorial
sectoral10109543sectoral
sporal82915453__sporal
stomal85213313__stomal
storax1389783__storax
vestral104111013vest_ral
vestural1156473vestural
wastrel1037553wast_rel

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621177.34319904.9
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.80922882.7
 
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.