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

132 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
penoche144704(None) 
panoche1456381panoche
penoches1538931penoches
penuche1435941penuche
panache1458422panache
panocha1444982panocha
panoches1548122panoches
pence94924452pen_c_e
penuches1536942penuches
penuchi1444032penuchi
penuchle1543762penuchle
pinochle1544742pinochle
pinocle1138142pinocle
bench125619503ben_ch_
benched154713943ben_ched
bencher144113483ben_cher
benches143918603ben_ches
binocle1136493binocle
boche124216953__boche
brioche14275923brioche
broche133612103_broche
caroche1469243caroche
cenacle1139123cenacle
cenote83715843ceno_te
ceviche1744143ceviche
cloche134312373_cloche
debouche16123773debouche
denote74118043deno_te
eche97520283_e__che
encode9310443_encode
encore8314773_encore
epoch1248203_epoch_
epochs1335813_epochs
fence105319913fen_c_e
ganache1346213ganache
genocide1245693genocide
genoise839423genoise
genome94312193geno_me
hence104920043hen_c_e
kench145513923ken_ch_
kenches163912273ken_ches
manche133515103man_che
menace103216943menac_e
menarche1545813menarche
mensch13387103mensch_
menschen1543713menschen
mensches1536303mensches
menschy17354013menschy
monocle1139663monocle
niche105016793__niche
panaches15310283panaches
panicle11129983panicle
panochas1545653panochas
peace95026083pe_ac_e
peach125422493pe_ach_
peached154315883pe_ached
peacher144216073pe_acher
peaches144120053pe_aches
peachy164510843pe_achy
pech116125453pe__ch_
peched144915343pe__ched
pechs125516203pe__chs
pedicle1238973pedicle
pedocal1237893pedocal
pekoe114612363peko__e
penance11313443penance
pencel103812913pen_cel
pencil103712973pen_cil
penicil1138833penicil
penile82219603pen_ile
penlite9313243penlite
pennae84314033pen_nae
penname11328553penname
pennate93314033pennate
penne75423853pen__ne
pennine93712953pennine
penoncel1244843penoncel
pensee8417313pen_see
pensile92713543pensile
pensive122610393pensive
pentacle1239383pentacle
pentane9415743pentane
pentene9313793pentene
pentode1039893pentode
pentose9311593pentose
penuchis1544283penuchis
penuchles1643763penuchles
penuckle1643263penuckle
peonage1048723peonage
people10310193pe_ople
perch124518833pe_rch_
perched154713243pe_rched
percher143313423pe_rcher
perches143717953pe_rches
peyote1139853peyo_te
pinch125619303pin_ch_
pinched153812453pin_ched
pincher143812713pin_cher
pinches144117933pin_ches
pinochles1644863pinochles
pinocles1248693pinocles
pinole83218783pino_le
pinscher1544813pinscher
planche14299753planche
plench134010813plen_ch_
plenches153110623plen_ches
ponce95222513pon_c_e
poncho133310123pon_cho
pooch124815303p_ooch_
pooched152810083p_ooched
pooches143214163p_ooches
potiche1438043potiche
psyche1674293p_syche
punch125118423pun_ch_
punched153512173pun_ched
puncher143311673pun_cher
punches144816133pun_ches
punchy16398523pun_chy
seiche11811833se_iche
seviche1545113seviche
soroche1237183soroche
spence103813793spen_c_e
tenace82715693tenac_e
tench105620003ten_ch_
tenches123515523ten_ches
troche113112513_troche
veloce11310133veloc_e
venose9310843veno_se
wench136214783wen_ch_
wenched163910913wen_ched
wencher153811133wen_cher
wenches152914133wen_ches

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.406440125.6
2DLD Change Limit1340271326.18621666.2
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.63826919.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.