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

157 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
planchet15251196(None) 
planche14299751planche_
planches153111861planches
planchets16236741planchets
blanched16308602blanched
blancher15338632blancher
blanches153311602blanches
lancet84223572_lanc_et
latchet123117902_latchet
manchet143317782_manchet
placet103923672pla_c_et
placket15412872pla_cket
planch133711442planch__
planchette1753082planchette
planet84228352plan__et
plantlet10310012plantlet
plenches153110622plenches
blanch133410853blanch__
blanchers16307433blanchers
blanket134313093blan_ket
blenched16358053blenched
blencher15308393blencher
blenches153310763blenches
brachet144020313bra_chet
branched163210453branched
branches153613803branches
branchlet1647183branchlet
cachet134526413_ca_chet
claucht1445583clauch_t
clenched16257763clenched
clencher15277973clencher
clenches152910953clenches
clinched16347383clinched
clincher15347663clincher
clinches153910363clinches
cranched163210413cranched
cranches153114543cranches
flenched17267963flenched
flenches163410533flenches
flinched17316703flinched
flincher16256583flincher
flinches16358953flinches
glance94312313glanc_e_
glanced11439233glanc_ed
glancer103710073glanc_er
glances104113143glanc_es
glunched1544263glunched
glunches1436263glunches
hatchet153317563_hatchet
klatches17157133klatches
laches116528343_la_ches
lance75126723_lanc_e_
lanced93717723_lanc_ed
lancelet1049473_lancelet
lancer84319973_lanc_er
lances84824103_lanc_es
lancets93411163_lanc_ets
languet8713693_languet
larchen12479623_larchen
larches124416443_larches
latched133914063_latched
latches123320123_latches
latchets133410013_latchets
launched1475403_launched
launcher1365563_launcher
launches1387903_launches
lunched133911823_lunched
luncher123111413_luncher
lunches124115443_lunches
lynched16376753_lynched
lyncher15366553_lyncher
lynches15378873_lynches
manche133515103_manche_
manches143818623_manches
manchets15269573_manchets
packet144726503p_a_cket
painches1588913painches
panache1458423p_anache_
panaches15310283p_anaches
panchax2134983p_anchax
panoche1456383p_anoche_
panoches1548123p_anoches
panther12611443p_anther
parched154013693p_arched
parches143720003p_arches
patched153514623p_atched
patcher143515143p_atcher
patches143320383p_atches
paunched1645523paunched
paunches1568173paunches
peached154315883pea_ched
peacher144216073pea_cher
peaches144120053pea_ches
pinched153812453p_inched
pincher143812713p_incher
pinches144117933p_inches
placate11312433pla_cate
place94824613pla_c_e_
placed114318003pla_c_ed
placer105117743pla_c_er
places104323703pla_c_es
placets113911223pla_c_ets
plackets1646583pla_ckets
plaice10311553plaic_e_
plaices11411143plaic_es
plainchant1752643plainchant
planate9314573planate_
planchettes1852683planchettes
plane74929143plan__e_
planed94420913plan__ed
planer84122653plan__er
planes85028083plan__es
planets93914083plan__ets
plangent1138803plangent
planished1566123planished
planisher1495853planisher
planishes14138523planishes
planked143512283plan_ked
plankter1435363plankter
planned103810153plan_ned
planner93511623plan_ner
plant75437113plan___t
planted103516123plan_ted
planter94017803plan_ter
plantlets1145013plantlets
plashed133712643pla_shed
plasher124215033pla_sher
plashes124417393pla_shes
platelet10510733platelet
playlet1239523pla_ylet
pleached16338063pleached
pleaches153210433pleaches
plench134010813plench__
pliancies1346673pliancies
poached154212403poa_ched
poacher143912323poa_cher
poaches144416943poa_ches
prance104318573pranc_e_
pranced123714043pranc_ed
prancer113613383pranc_er
prances113618773pranc_es
punched153512173p_unched
puncher143311673p_uncher
punches144816133p_unches
rachet115028973_ra_chet
ranched133113603_ranched
rancher123013633_rancher
ranches123620113_ranches
ratchet124218333_ratchet
sachet114725773_sa_chet
slatches131511523slatches
stanched14208903stanched
stancher13198813stancher
stanches132312793stanches
stanchest14218213stanchest
tranche123312223tranche_
tranches132915513tranches

Search took 9 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.406440125.6
2DLD Change Limit1461621577.53319402.9
3Display Results1571570.0602616.7
 (SQL Overall)1786911577.99922339.2
 
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.