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

102 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
pleural95667(None) 
pleura837531pleura_
pleurae945861pleurae
pleuras937411pleuras
plural839821pl_ural
flexural1842442flexural
neural6311992_neural
pleonal937242pleonal
pleuron976342pleuron
plexal1536832ple_xal
plurals936912pl_urals
preoral9312672preoral
aleuron757383aleuron
anural65714743_anural
apteral9311523apte_ral
augural856403augural
aural54428963__aural
caesural1055383caesural
clausal936273clausal
crural8610633_crural
cultural1047253cultural
dural64923893__dural
epidural1143723epidural
feral85424653_fe_ral
feudal1037683_feudal
figural1145233figural
fleuron1055573fleuron
fleury12417353fleur_y
floral94313813fl_oral
futural1037283futural
ileal56118083ile__al
jural125120483__jural
laura54116203_laura_
laurae64011663_laurae
lauras63414333_lauras
laurel649033_laurel
leal46043273_le__al
legal65715943_le_gal
lethal939803_lethal
loral55927823_l_oral
mural75225103__mural
natural739513natural
neutral737923_neutral
paleal84716673pale__al
palestral1145323palestral
palpebral1542213palpebral
paludal1035683paludal
papyral1445773papyral
parral85517533p_arral
parura8310583parura_
paruras9310533paruras
pastural1038413pastural
pausal81511963p_ausal
peal68648103p_e__al
pearl75324463p_ear_l
pedal86022503p_e_dal
penal75228373p_e_nal
penial84120893p_enial
peril75425953p_e_ril
peroral9314793peroral
perusal939193perusal
petal76526893p_e_tal
petrale9312623p_etrale
petrel83111533p_etrel
petrol82714063p_etrol
peytral1287503peytral
plagal948573pl_agal
plastral1046913plastral
plea66830603ple__a_
plead85818463ple__ad
pleas75627033ple__as
pleat74734473ple__at
plectra1145783plectra_
pleiad947833ple_iad
plena75816393ple_na_
plenary1237543plenary
pleurisy1343663pleurisy
plical10411683pl_ical
plurally1345803pl_urally
pluvial1245433pluvial
pneuma1035263pneuma_
pneumas1145103pneumas
postural1049193postural
preanal9310713preanal
predial103815413predial
premeal11310513premeal
premoral1249713premoral
prepupal1164263prepupal
pretrial10511983pretrial
prewrap14104973prewrap
procural1246923procural
puberal1147773puberal
pupal97616873p__upal
purl65631423p__ur_l
retral64419743_retral
rural55821173__rural
scleral937863scle_ral
seral56336383_se_ral
spheral1238423sphe_ral
splenial1047183splenial
sural55931263__sural
sutural7310223sutural

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 Limit1340271027.76617258.2
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.96822426.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.