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

85 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
plectra114578(None) 
electro92810032electro
olestra746172olestra
palestra1045882palestra
plectron12228022plectron
plectrum1453952plectrum
pleura837532ple_ura
spectra11275832spectra
centra84113883_centra
ejecta15337393eject_a
elect74327033elect__
elected102812613elected
electee92513243electee
elector93313253elector
electoral1156723electoral
electors103013843electors
electret10411993electret
electric1249183electric
electron102611413electron
electros102811743electros
electrum1245213electrum
elects83315003elect_s
elytra934893el_ytra
extra1239003__extra
lectern937033_lectern
lectin82515013_lectin
lector83514983_lector
lectors93415763_lectors
lecture9149513_lecture
lepta75714393_lept_a
lustra6358893_lustra
lycra10317973_lyc_ra
nectar838853_nectar
olestras846583olestras
osetra667423ose_tra
palaestra1142783palaestra
palestrae1145373palestrae
palestral1145323palestral
palestras1145723palestras
pecten102711103p_ecten
pectic122913873p_ectic
pectin102615533p_ectin
pectoral121210503p_ectoral
pelota8612833pelot_a
peltry11288653p_eltry
peytral1287503p_eytral
philtra12103683philtra
picara10311903p_icara
piecer105213083piecer_
piecers114112253piecers
pieta75421753pie_t_a
placard1236783placard
placer105117743placer_
placers114515263placers
plantar9369993plantar
plastral1046913plastral
plea66830603ple___a
pleat74734473pleat__
pleated103816633pleated
pleater93916333pleater
pleaters103613793pleaters
pleats85218593pleat_s
plectrons13258073plectrons
plectrums1553033plectrums
plena75816393ple__na
plenary1237543plenary
plenty11311413plent_y
plethora1344823plethora
pleurae945863ple_urae
pleural956673ple_ural
pleuras937413ple_uras
plexor1535253plexor_
plexors1645423plexors
plica9613373plic__a
poetry1139383poe_try
polenta9310093polent_a
polestar1047113polestar
precava1445093precava
precure11312553precure
recta74220263_rect_a
spectral12246193spectral
spectre11297773spectre
tecta74215523_tect_a
tetra53417953_te_tra
ultra539363ul__tra

Search took 7 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.423422437.4
2DLD Change Limit134027855.89022755.0
3Display Results85850.0332575.8
 (SQL Overall)178691856.34628158.1
 
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.