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 “pleonam” 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
pleonal937241pleonal
pleonasm1243811pleonasm
plena75816392ple_na_
plenum1039502ple_num
pleon74216382pleon__
pleonasms1342852pleonasms
pleonic1139432pleonic
pleons84213342pleon_s
allonym1244733allonym
clonal8310913cl_onal
fleam106017283fle__am
gleam86916733gle__am
gloam86015943gl_o_am
leone55018823_leon_e
leones64417723_leones
loam65630483_l_o_am
paeon74819493paeon__
paeons83915523paeon_s
paronym1437503paronym
pelon74423213pelon__
pelota8612833pelota_
pelotas9410723pelotas
penal75228373p_e_nal
penna74520203p_enna_
pennae84314033p_ennae
penname11328553p_enname
peon65635243p_eon__
peonage1048723p_eonage
peones83821043p_eones
peonism11611103p_eonism
peons75327183p_eon_s
peony105717563p_eon_y
petnap1037423p_etnap
phenom1339473phe_nom
phonal11310383p_honal
planar84212713pl_anar
plea66830603ple__a_
plead85818463ple__ad
pleas75627033ple__as
pleat74734473ple__at
pleiad947833ple_iad
plenary1237543ple_nary
plench134010813ple_nch
plenism11310113plenism
plenty11311413ple_nty
plenums1136533ple_nums
pleopod1244823pleopod
pleura837533pleura_
pleurae945863pleurae
pleural956673pleural
pleuras937413pleuras
plexal1536843ple_xal
plonk114613983pl_on_k
plonks124210423pl_onks
preanal9310713preanal
prename11412643pre_name
preoral9312673preoral

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.406440125.6
2DLD Change Limit134027576.62620227.4
3Display Results57570.0163562.5
 (SQL Overall)178691577.04825353.4
 
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.