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

163 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
pinocles124869(None) 
binocles1236411binocles
pinochles1644861pinochles
pinocle1138141pinocle_
pinoles93418701pino_les
binocle1136492binocle_
monocles12310672monocles
panicles121010112panicles
panoches1548122panoches
penoches1538932penoches
pinches144117932pin_ches
pinholes131810662pinholes
pinnacles13276042pinnacles
pinnules1036462pinnules
pinochle1544742pinochle_
pinole83218782pino_le_
pinones94717072pino_nes
pintles94118722pin_tles
pinwales1367962pinwales
anoles64827433_ano_les
bicycles1743883bicycles
bindles104016453bin_dles
binnacles13244583binnacles
binocs1039923binoc__s
cenacles1238023cenacles
ciboules1244533ciboules
cinches144215773cin_ches
cineoles10109403cineoles
circles1139903ci_rcles
citoles9312553cito_les
dindles93817243din_dles
dingles93818323din_gles
dipoles101013753dipo_les
ennobles1045113ennobles
epicycles1843383epicycles
finagles12237553finagles
finales104016013fin_ales
finches153914193fin_ches
funicles13246833funicles
girolles935523girolles
icicles1135943_icicles
inches114419673_in_ches
incomes11712373_incomes
indoles83716363_indoles
ingles74420873_in_gles
inhales10511863_inhales
inkles103515653_in_kles
insoles73516243_insoles
jingles153816383jin_gles
kindles123614843kin_dles
linocuts1094573linocuts
manacles1239523manacles
minces104420803min_c_es
mingles103719003min_gles
miracles1238333miracles
monocle1139663monocle_
monocled1337113monocled
nobles83319723__nobles
nuncles939843nun_cles
oinomels1044513oinomels
painches1588913pain_ches
panaches15310293panaches
panicle11129983panicle_
panicled13106783panicled
panochas1545653panochas
panoche1456383panoche_
panoplies1346003panoplies
pantiles103617153pantiles
pantofles1474863pantofles
paroles95025883paro_les
pedicles1338683pedicles
pencels113610053pen_cels
penoche1447043penoche_
penoncels1343593penoncels
pentacles1338773pentacles
penuches1536943penuches
penuchles1643763penuchles
penuckles1743243penuckles
peoples11312223p_eoples
piccolos1444133piccolos
pickles153215443pi_ckles
picomoles1545913picomoles
picotees1247113picotees
piddles114314273pi_ddles
pieces104217273pi_ec_es
pieholes13168913pieholes
pierces113411193pierc_es
piffles15368763pi_ffles
pignolis1146053pigno_lis
piles74742613pi___les
pilotless1143993pilotless
pilules9510623pi_lules
pimples133012423pi_mples
pinballs1246933pinballs
pinbones1238143pinbones
pincer104019173pin_c_er
pincers113916503pin_cers
pinched153812453pin_ched
pincher143812713pin_cher
pinchers153510613pin_chers
pineals93212843pineal_s
pinecones1346253pinecones
pinenes93416673pin_enes
pineries102419083pineries
pines76048863pin___es
pinfolds1445143pinfolds
pingoes105116523pin_goes
pinhole122010433pinhole_
pinites9319533pin_ites
pinkeyes17335973pinkeyes
pinkies133818263pin_kies
pinkoes135512313pin_koes
pinnaces12268863pinnaces
pinnacle12416963pinnacle_
pinnacled14304503pinnacled
pinnies93318443pin_nies
pinnule936003pinnule_
pinons86019943pino__ns
pinots85920273pino__ts
pinscher1544813pinscher
pinschers1644383pinschers
pintle83818263pin_tle_
pintoes95117713pin_toes
pinwale1257843pinwale_
piolet83225643pi_o_let
piolets93513193pi_o_lets
piracies12312643piracies
pirogies1139423pirogies
pirogues1135473pirogues
piroques1944353piroques
pistoles102514723pistoles
pitches143617753pi_tches
pizzles17329273pi_zzles
poles75351003p__o_les
ponces104720843pon_c_es
pooches143214163p_ooches
poodles103013513p_oodles
posoles9314883poso_les
pozoles1839063pozo_les
princes113015143prin_c_es
princoxes2044083princoxes
proles84627203p_ro_les
punches144816133pun_ches
pungles104013713pun_gles
sanicles10149943sanicles
silicles1037073silicles
singles83520433sin_gles
socles8418453__socles
spinaches1645273spinaches
spindles112710353spin_dles
spinelles1146083spinelles
spinules10249333spin_ules
spiracles1345663spiracles
tingles83818323tin_gles
tinkles113713923tin_kles
tunicles10217133tunicles
uncles8317163_un_cles
winces114819113win_c_es
winches154714373win_ches
windles113518493win_dles
winkles143412773win_kles
winoes94317013wino__es
wintles103414983win_tles

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621636.53022383.2
3Display Results1631630.0802037.5
 (SQL Overall)1786911637.01625469.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.