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

266 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
planche1429976(None) 
planch133711441planch_
planches153111871planches
planchet152511971planchet
blanch133410852blanch_
blanched16308602blanched
blancher15338632blancher
blanches153311612blanches
glance94312312glanc_e
lance75126722_lanc_e
manche133515102_manche
panache1458432p_anache
panoche1456382p_anoche
place94824612pla_c_e
plaice10311552plaic_e
planate9314572planate
planchets16236752planchets
plane74929142plan__e
plench134010812plench_
plenches153110632plenches
prance104318572pranc_e
tranche123312222tranche
ache96829823__a_che
alane56135613alan__e
alanine7316863alanine
ancho104515303__ancho
apache134210783apa_che
avalanche17112513avalanche
balance11510263balanc_e
blanchers16307433blanchers
blench133710453blench_
blenched16358053blenched
blencher15308393blencher
blenches153310763blenches
branch134014783branch_
branched163210453branched
branches153613803branches
branchy17357913branchy
cache125122483_ca_che
caleche14297953caleche
caliche14329963caliche
cancha134411613_cancha
chance134617093chanc_e
chancre14348783chancre
clach124617823cla_ch_
clachs133511323cla_chs
claucht1445583claucht
clench133910053clench_
clenched16257763clenched
clencher15277973clencher
clenches152910953clenches
cliche133712453cl_iche
clinch133910353clinch_
clinched16347383clinched
clincher15347663clincher
clinches153910373clinches
cloche134312373cl_oche
cranch133613533cranch_
cranched163210413cranched
cranches153114543cranches
dance85223133_danc_e
elenchi1244723elenchi
fiance11310743fianc_e
fiancee1238953fiancee
flange103411973flan_ge
fleche14299303fl_eche
flench144010813flench_
flenched17267963flenched
flenches163410533flenches
flinch144010103flinch_
flinched17316703flinched
flincher16256583flincher
flinches16358963flinches
ganache1346223_ganache
gauche1238563_gauche
glace87420163gla_c_e
glanced11439233glanced
glancer103710073glancer
glances104113143glances
glunch1255353glunch_
glunched1544263glunched
glunches1436263glunches
hance105424153_hanc_e
kalanchoe1851863kalanchoe
klatch15445933klatch_
klatches17157143klatches
lace66848473_la_c_e
laches116528353_la_ches
laich105920713_laich_
laichs115110893_laichs
lanate6421263_lanate
lanced93717723_lanced
lancer84319973_lancer
lances84824103_lances
lancet84223573_lancet
lane45153333_lan__e
langue71012183_langue
lanose6313593_lanose
larch105919793_larch_
larchen12479633_larchen
larches124416453_larches
latch104620463_latch_
latched133914073_latched
latches123320133_latches
latchet123117913_latchet
lathe85626723_la_the
launce8469183_launc_e
launch11368063_launch_
launched1475403_launched
launcher1365563_launcher
launches1387913_launches
louche115212663_louche
lunch104917243_lunch_
lunched133911823_lunched
luncher123111413_luncher
lunches124115443_lunches
lynch13468983_lynch_
lynched16376753_lynched
lyncher15366553_lyncher
lynches15378873_lynches
mache125925303_ma_che
manches143818623_manches
manchet143317783_manchet
nance74721843_nanc_e
nuance859043nuanc_e
orache114013593ora_che
pace86345773p_a_c_e
pacha126518063p_a_cha
painch133511323painch_
painches1588933painches
palace104516923palac_e
panaches15310293p_anaches
pancake1536673p_ancake
panchax2134983p_anchax
pane64950293p_an__e
panicle11129983p_anicle
panne76623653p_an_ne
panocha1444983p_anocha
panoches1548133p_anoches
panther12611443p_anther
pantie84326473p_antie
parch125123003p_arch_
parched154013693p_arched
parches143720003p_arches
parlance1248723parlanc_e
patch125221223p_atch_
patched153514623p_atched
patcher143515143p_atcher
patches143320383p_atches
patchy16509573p_atchy
paunch13369853paunch_
paunched1645523paunched
paunches1568183paunches
paunchy17324443paunchy
peace95026083pea_c_e
peach125422493pea_ch_
peached154315883pea_ched
peacher144216073pea_cher
peaches144120053pea_ches
peachy164510843pea_chy
penance11313443penanc_e
pence94924453p_enc_e
penoche1447043penoche
penuche1435943penuche
pinch125619303p_inch_
pinched153812453p_inched
pincher143812713p_incher
pinches144117943p_inches
placate11312433placate
placed114318003pla_ced
placer105117743pla_cer
places104323703pla_ces
placet103923673pla_cet
placid114012543pla_cid
plack135017843pla_c_k
placket15412873pla_cket
placks144414153pla_cks
plage84520403pla__ge
plague93610853pla_gue
plaices11411153plaices
plan65833943plan___
planar84212713plan_ar
planchette1753093planchette
planed94420913plan_ed
planer84122663plan_er
planers94517953planers
planes85028083plan_es
planet84228353plan_et
planets93914083planets
planing103418253planing
planish12412063planish
planished1566123planished
planisher1495853planisher
planishes14138533planishes
plank115221143plan__k
planked143512283planked
planks124116753plan_ks
plankter1435363plankter
planned103810153planned
planner93511633planner
plans75731273plan__s
plant75437113plan__t
plantar9369993plantar
planted103516123planted
planter94017813planter
plantlet10310013plantlet
plants84921803plan_ts
planula935773planula
planulae1044793planulae
plaque17317643pla_que
plash104616563pla_sh_
plashed133712643pla_shed
plasher124215033pla_sher
plashes124417393pla_shes
plashy14448873pla_shy
platane93112303platane
plate74635113pla__te
pleach134211243pleach_
pleached16338063pleached
pleaches153210433pleaches
pliancies1346683pliancies
pliancy1435593plianc_y
plicae10410953pl_icae
plinth11310453plinth_
plinths1236133plinths
plunge93811063plun_ge
poach124917863poa_ch_
poached154212403poa_ched
poacher143912323poa_cher
poaches144416943poa_ches
poachy16388963poa_chy
ponce95222513p_onc_e
poncho133310123p_oncho
potiche1438043potiche
potlache15114283potla_che
pounce105214093pounc_e
pranced123714043pranced
prancer113613383prancer
prances113618783prances
prince104114763princ_e
psyche1674293p_syche
punch125118423p_unch_
punched153512173p_unched
puncher143311673p_uncher
punches144816133p_unches
punchy16398523p_unchy
rance75028513_ranc_e
ranch105019793_ranch_
ranched133113603_ranched
rancher123013633_rancher
ranches123620113_ranches
rancho114310853_rancho
revanche1645003revanche
seance83716693seanc_e
slatch114510533slatch_
slatches131511533slatches
stance84316913stanc_e
stanch113812373stanch_
stanched14208903stanched
stancher13198813stancher
stanches132312793stanches
tache106222373_ta_che
trance84718763tranc_e
tranches132915513tranches
usance858013usanc_e
valance1269253valanc_e

Search took 10 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 Limit1340272669.36014319.1
3Display Results2662660.0932860.2
 (SQL Overall)1786912669.85918124.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.