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 “papyral” 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
papyral144577(None) 
caporal11410942caporal
papal95820672pap__al
papyri1334902papyr_i
papyrian1544562papyrian
papyrus1444062papyrus
parral85517532pa_rral
aboral8314373_aboral
amoral8314633_amoral
antral65719413_antral
anural65714743_anural
apical10913903_apical
apneal83411123_apneal
apodal9289833_apodal
appal95315223_ap_pal
apparat11711713apparat
apparel1146003apparel
appeal103911613_appeal
apteral9311523apteral
apyrase1236363_apyrase
astral66919283_astral
aural54428963_a_ural
butyral1245713butyral
cameral11311283cameral
capital112311523capital
caporals1238923caporals
empyreal1542673empyreal
gastral8329553gastral
gayal9312713ga_y_al
gyral94412783__gyral
lateral7313573lateral
mayoral1237693mayoral
nadiral836343nadiral
natural739513natural
paginal10269493paginal
pakora1247283pakora_
pakoras1337473pakoras
palatal9310153palatal
paleal84716673pa_leal
pallial92911253pallial
palmyra1444143palmyra_
palmyras1544033palmyras
palpal104112053pa_lpal
palpebral1542213palpebral
paludal1035683paludal
pangram1239023pangram
papa85827143pap__a_
papadam1486913papadam
papas94927493pap__as
papaw125112493pap__aw
papaya1337503papaya_
papayan1445303papayan
papayas1437273papayas
paper95128663paper__
papered122513163papered
paperer113111903paperer
papers105125323paper_s
papery134812743paper_y
paphian1437453paphian
papilla11127913papilla
papula103011113papula_
papulae11249353papulae
papular11299763papular
papyrine1546053papyrine
para65242173pa__ra_
parae76335703pa__rae
paras76143043pa__ras
parol74826273pa__rol
parrals94414573pa_rrals
parrel84515983pa_rrel
partial92616263partial
parura8310583parura_
paruras9310533paruras
pascal10812373pa_scal
paschal14157243paschal
pastoral10310483pastoral
pastural1038413pastural
paternal1038333paternal
patrol83213023pa_trol
pausal81511963pa_usal
payday1536613pa_yday
payola11208113pa_yola
payroll1245613pa_yroll
peroral9314793peroral
peytral1287503peytral
pipal95118353pip__al
plastral1046913plastral
pleural956673pleural
plural839823p_lural
preoral9312673preoral
puberal1147773puberal
pupal97616873pup__al
puparial1246313puparial
pyran10514473__pyran
sacral83414413sa_cral
spiral83715343_spiral
sporal82915453_sporal
tapetal938273tapetal

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027986.81319672.2
3Display Results98980.0303266.7
 (SQL Overall)178691986.99925530.9
 
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.