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

98 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
prenatal104837(None) 
parental10310942paren_tal
perinatal1146482perinatal
preanal9310712pre_anal
prebasal1244722prebasal
precaval1544722precaval
prenatally1544992prenatally
primatal1247132primatal
rental63922022_ren_tal
antenatal964773antenatal
argental947933argen_tal
cental84420963_cen_tal
crenate93317113crenat_e
crenated113013913crenated
crenately1444783crenately
crestal9312133cre_stal
dental74319173_den_tal
frontal1038363fron_tal
genital849793_genital
haematal1345143haematal
hematal1238953_hematal
irenical1048553irenical
meatal84114733_me_atal
mental84521603_men_tal
natal53921493___natal
neonatal844383neonatal
omental93210413omen_tal
oriental848483orien_tal
orinasal843563orinasal
palatal9310153p_alatal
penal75228373p_en__al
penates93321603p_enates
penial84120893p_en_ial
pentad9313763p_en_tad
pentyl1138813p_en_tyl
percental1348663percen_tal
perennial1147233perennial
petal76526893p_e__tal
phenate12412203phenat_e
phenates13611583phenates
phenetol1344063phenetol
pinata83817223p_inata_
pinatas93711503p_inatas
postnatal1144463postnatal
prandial1149643prandial
preaxial1746973preaxial
prebattle1343013prebattle
precaudal1443413precaudal
precava1445093precava_
precavae1544813precavae
precoital1347273precoital
predate10616893predat_e
predated12513273predated
predates11615813predates
predator11310053predator
predial103815413pre_dial
prefixal2044543prefixal
pregenital1345153pregenital
prelate9519693prelat_e
prelates10418573prelates
prelatic12311283prelatic
prelegal1145053prelegal
premarital1455023premarital
premeal11310523pre_meal
premoral1249713premoral
prename11412643prena_me
prenames12311643prenames
prenuptial1453393prenuptial
preoral9312673pre_oral
prepupal1164263prepupal
preputial1345673preputial
prerectal1345693prerectal
prerenal1049083prerenal
pretax152310193pre__tax
pretrial10511983pretrial
prevail1238243preva_il
primatals1345143primatals
primatial1348103primatial
pronate9418873pronat_e
pronated11414053pronated
pronates10418373pronates
pronator10311783pronator
pronota939763pronota_
ratal55025113_r__atal
reata54225393_re_ata_
reatas64021013_re_atas
recital9412163_recital
rectal84418133_re_ctal
refutal1046943_refutal
remnantal1142533_remnantal
renail65020763_rena_il
renal55929503_ren__al
renewal1038703_renewal
rentals74017473_ren_tals
retotal739843_retotal
serenata8197673serenata_
serenatas9145193serenatas
trenail7410813trena_il

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 Limit146162986.69021847.8
3Display Results98980.0462130.4
 (SQL Overall)178691987.15624970.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.